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::Wri
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
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.
Using this:
while ( $row = $sth->fetchrow_arrayref ) {
# this is a fas
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
> assumptions about what you're fetching).
>
> - Amy
>
> On 5/9/2005 12:45 PM, Rob
ted just that
portion and left out 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@p
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
you want to keep straight which rows are which, you need something
like this:
# Use [] to make sure each row is a separate array reference.
push @results, [ @$row ];
}
my $workbook = Spreadsheet::WriteExcel->new("report.xls");
$worksheet = $workbook->add_worksheet();
$wo
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
@$row);
}
my $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:
s1
