Hi list,
I have installed Spreadsheet::WriteExcel and Parse::RecDescent without any
issues, compilation and installation went went but they are not working.
bash-2.05# perl -MSpreadsheet::WriteExcel
Spreadsheet/WriteExcel.pm did not return a true value.
bash-2.05# perl
On Fri, 2006-02-24 at 05:56 -0800, Robert wrote:
Hi list,
I have installed Spreadsheet::WriteExcel and Parse::RecDescent without any
issues, compilation and installation went went but they are not working.
bash-2.05# perl -MSpreadsheet::WriteExcel
Spreadsheet/WriteExcel.pm
Robert,
I think your problem is not in the while loop, but in your use of
write_row. (Which I guess makes this answer off-topic, if not the
question itself.) Try write_col. The perldoc for
Spreadsheet::WriteExcel describes this behavior, with detailed
examples (granted, I'm having to make some
the Spreadsheet stuff because once I know what is
coming out of the while statement I can do the rest of the Spreadsheet
stuff.
Robert
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Mon 5/9/2005 1:45 PM
To: dbi-users@perl.org
Subject: Spreadsheet::WriteExcel question
write_col. The perldoc for Spreadsheet::WriteExcel describes
this behavior, with detailed examples (granted, I'm having to make some
assumptions about what you're fetching).
- Amy
On 5/9/2005 12:45 PM, Robert wrote:
My ignorance is showing. : )
I am pulling data out of Oracle
]
Sent: Mon 5/9/2005 1:45 PM
To: dbi-users@perl.org
Subject: Spreadsheet::WriteExcel question
My ignorance is showing. : )
I am pulling data out of Oracle and putting it into an Excel spreadsheet.
Using this:
while ( $row = $sth-fetchrow_arrayref ) {
# this is a fast and simple way to deal
$workbook = Spreadsheet::WriteExcel-new(report.xls);
$worksheet = $workbook-add_worksheet();
$worksheet-write_row('A2', [EMAIL PROTECTED]);
It give me columns of the data:
sss
134
ABC
Where I am looking for rows:
s1A
s3B
s4C
I know it has to do
This is really off topic.
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Mon 5/9/2005 1:45 PM
To: dbi-users@perl.org
Subject: Spreadsheet::WriteExcel question
My ignorance is showing. : )
I am pulling data out of Oracle and putting it into an Excel spreadsheet
is a separate array reference.
push @results, [ @$row ];
}
my $workbook = Spreadsheet::WriteExcel-new(report.xls);
$worksheet = $workbook-add_worksheet();
$worksheet-write_row('A2', [EMAIL PROTECTED]);
I can't say what this does because this isn't the Spreadsheet list.
--
Mac :})
** I usually forward