in reply to Reading from Excel
As I mentioned deeper in the response tree, you might need to calculate the page, especially if you have DisplayAlerts = 0 or the cell references data from another sheet.
It's happened to me before.use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application', 'Quit'); $Excel->{DisplayAlerts}=0; my $Book = $Excel->Workbooks->Open($excelfile); my $Sheet = $Book->Worksheets("Sheet1"); $Sheet->Activate(); $Sheet->Calculate(); #The rest of your GET code here
C-.
---
Flex the Geek
|
---|
Replies are listed 'Best First'. | |
---|---|
Enabling macros
by migs (Initiate) on Aug 10, 2002 at 19:48 UTC | |
by cacharbe (Curate) on Aug 10, 2002 at 22:35 UTC | |
by Anonymous Monk on Mar 31, 2008 at 14:49 UTC |
In Section
Seekers of Perl Wisdom