Mario Sanchez wrote:
hello everyone,
can you please point me to a package or script that will first determine
the columns of a database table, then output well formed XML? condition: i
do not know in advance the columns of the table.
example output where "field" = actual field name
Mary Anderson wrote:
> Hi all,
>I am writing an application (my first!) which calls for a screen with a
> half dozen or so popup-menus. My test program with two popup-menus
> displays the first one correctly with the four choices I gave it. The
> second one displays with only one choice. If
Ken
Thank you for your great idea. I did not think into this
direction
Erich
From: Ken Barker
[mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08,
2006 3:40 PMTo: Erich Singer; [EMAIL PROTECTED]; Todd
BeverlyCc: activeperl@listserv.ActiveState.comSubject: RE:
Importing into Excel
The
The way I accomplish this is
to write the data to an SQL table and then do queries for the specific tab of
the desired worksheet. Depending upon how many tabs it can get a bit messy
with all of the while loops - but it eliminates the manual process of
pasting.
Ken
Ken Barker
IT Lea
You're recollection is correct, Spreadsheet::WriteExcel will not write into an existing Excel file. As to alternatives, I pass *that* hot potato to those who know more than I about Perl.
D.
"Erich Singer" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/08/2006 13:36
Hello
I would like to thank you for your suggestions.
However, in the meantime I found a
solution.
1 Delete (if any) leading and trailing spaces from the
original string.
2 Replace original string 00123456789 with
="00123456789".
With this opportunity I would like to ask another
que
Erich Singer wrote:
I am using PERL (Spreadsheet::WriteExcel)on Windows to import data into
Excel 2003. Everything is working fine, except when I have to import a
string that contains only numbers, such as 00123456789. It gets
imported as 123456789, e.g. missing the leading 00. A solution cou
use
$worksheet->keep_leading_zeros();
- Original Message -
From: "Erich Singer" <[EMAIL PROTECTED]>
To:
Sent: Wed, 8 Feb 2006 08:24:41 -0800
Subject: Importing into Excel
Good Morning
I am using PERL (Spreadsheet::WriteExcel)on Windows to import data into
Excel 2003. Everythi
Hi all,
I am writing an application (my first!) which calls for a screen with a
half dozen or so popup-menus. My test program with two popup-menus
displays the first one correctly with the four choices I gave it. The
second one displays with only one choice. If I comment out one or the
other
amit hetawal wrote:
>
> Hello all,
> I am writing a matrix to a file as :
>
> open(WRITE, ">training.txt");
> for ($x = 1; $x<27; ++$x)
> {
> for($y=1; $y<27;++$y)
> {
> print WRITE "$matrix[$x][$y] ";
> }
> print WRITE "\n";
>
> }
>
> this code is working fine and writing the fil
Good Morning
I am using PERL (Spreadsheet::WriteExcel)on Windows to import data into
Excel 2003. Everything is working fine, except when I have to import a
string that contains only numbers, such as 00123456789. It gets
imported as 123456789, e.g. missing the leading 00. A solution could be
to
hello everyone,
can you please point me to a package or script that will first determine
the columns of a database table, then output well formed XML? condition: i
do not know in advance the columns of the table.
example output where "field" = actual field name
foo
...
The code which i am using has the logic as since there as spaces between each comumn so i just divide it in number of words in one line as different such :
0 0 0 0 0 //so i have them in an arry and then store theses values in the new matrix the code for this is as...
open(TRAINER, '/perl/bin/test
Brian Raven schreef:
> Tamas Dober:
>> my @ls = ( '\/perl\/Feb\/packager\/bin\/package.bat' ) ;
>
> Shouldn't those '\/' be '\\' ??
No need, better use just '/'.
my @ls = qw( /perl/Feb/packager/bin/package.bat );
--
Affijn, Ruud
"Gewoon is een tijger."
_
Steve Dawson <> wrote:
> amit hetawal wrote:
>
>>
>> ?
>> Hello all,
>> I am writing a matrix to a file as :
>>
>> open(WRITE, ">training.txt");
>> for ($x = 1; $x<27; ++$x)
>> {
>> for($y=1; $y<27;++$y)
>> {
>> print WRITE "$matrix[$x][$y] ";
>> }
>> print WRITE "\n";
>>
>> }
>>
amit hetawal wrote:
?
Hello all,
I am writing a matrix to a file as :
open(WRITE, ">training.txt");
for ($x = 1; $x<27; ++$x)
{
for($y=1; $y<27;++$y)
{
print WRITE "$matrix[$x][$y] ";
}
print WRITE "\n";
}
this code is working fine and writing the file in format as ;
0 0 0 0 0
16 matches
Mail list logo
