Sent: Monday, August 28, 2006 3:44 PM
To: beginners@perl.org
Subject: Reading Excel spreadsheet into variables
$everything = $sheet->UsedRange()->{Value};
for (@$everything)
{
for (@$_)
{
print defined($_) ? "$_|" : "|";
}
print "\n&q
I don't know about Win32::OLE, but you could use Data::Dumper to print
$everything to STDERR and see how it looks inside.
print STDERR Dumper $everything;
On Mon, 28 Aug 2006 18:43:35 -0400
[EMAIL PROTECTED] ("Stephan Gross") wrote:
> I'm reading in an Excel spreadsheet using Win32::OLE. I
d question, you would have to show us more of your code
to be sure.
-Original Message-
From: Stephan Gross [mailto:[EMAIL PROTECTED]
Sent: Monday, August 28, 2006 3:44 PM
To: beginners@perl.org
Subject: Reading Excel spreadsheet into variables
However, I don't understand what @$e
I'm reading in an Excel spreadsheet using Win32::OLE. I want to read in
the entire spreadsheet. I found a piece of code that does that:
$everything = $sheet->UsedRange()->{Value};
for (@$everything)
{
for (@$_)
{
print defined($_) ? "$_|" : "|";
}
print "\n";
}
However
