in reply to Re: Re: Re: Reading from Excel
in thread Reading from Excel
OK, here's the thing:
I can't give you the spreadsheet, it's not mine, sorry (company policy)...
When I print out the $value, I get the same result over and over (that is "-2146826259", and the expected result should be a positive number not bigger than 100,000). If I use:
to retrieve cell data then I get #NAME!.
I even tried debugging like this:
and it returns "10", which is VT_ERROR. I repeat, when you look at it in Excel application, it displays the correct results.
my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32: +:OLE->new('Excel.Application', sub {$_[0]->Quit;}); my $Book = $Excel->Workbooks->Open(MYFILE, 1, 1); my $Sheet = $Book->Worksheets("WORKSHEETNAME"); $Sheet->Activate(); my $value = $Sheet->Range("SOMECELL")->{Value};
I can't give you the spreadsheet, it's not mine, sorry (company policy)...
When I print out the $value, I get the same result over and over (that is "-2146826259", and the expected result should be a positive number not bigger than 100,000). If I use:
my $value = $Sheet->Range("SOMECELL")->Text();
to retrieve cell data then I get #NAME!.
I even tried debugging like this:
if (ref($value)) { print $value->Type(); }
and it returns "10", which is VT_ERROR. I repeat, when you look at it in Excel application, it displays the correct results.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Re: Re: Re: Reading from Excel
by dimmesdale (Friar) on Aug 09, 2002 at 18:50 UTC | |
Re:(5) Reading from Excel
by cacharbe (Curate) on Aug 09, 2002 at 19:23 UTC |
In Section
Seekers of Perl Wisdom