thorvid_461 has asked for the wisdom of the Perl Monks concerning the following question:
Here is what I'm trying to do:
I'm trying to open an XLSX file to read the contents from the spreadsheets. I had the code working for xls files but now I'm having problems getting the script to work with xlsx files.
Below is the code I had to open xls files:
my $xls_file = "File Path is here";
my $xl_app = CreateObject OLE 'Excel.Application' || die $!;
$xl_app->{'Visible'} = 0; # Set Application Visibility, 0 = Not Visible
my $workbook = $xl_app->Workbooks->Open($xls_file);
Now i need to modify the 4th line so the script will open the file and be able to read the contents that are in the file.
Any help/suggestions will be greatly appreciated.
Below is the code I had to open xls files:
my $xls_file = "File Path is here";
my $xl_app = CreateObject OLE 'Excel.Application' || die $!;
$xl_app->{'Visible'} = 0; # Set Application Visibility, 0 = Not Visible
my $workbook = $xl_app->Workbooks->Open($xls_file);
Now i need to modify the 4th line so the script will open the file and be able to read the contents that are in the file.
Any help/suggestions will be greatly appreciated.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Read XLSX Files
by steve (Deacon) on Apr 22, 2009 at 15:38 UTC | |
Re: Read XLSX Files
by dHarry (Abbot) on Apr 22, 2009 at 14:56 UTC | |
Re: Read XLSX Files
by Corion (Patriarch) on Apr 22, 2009 at 14:56 UTC | |
Re: Read XLSX Files
by jmcnamara (Monsignor) on Apr 22, 2009 at 21:15 UTC | |
Re: Read XLSX Files
by spectre9 (Beadle) on Apr 23, 2009 at 16:20 UTC | |
Re: Read XLSX Files
by Anonymous Monk on Apr 22, 2009 at 15:00 UTC | |
by Anonymous Monk on Apr 22, 2009 at 15:36 UTC | |
by Corion (Patriarch) on Apr 22, 2009 at 15:58 UTC |
Back to
Seekers of Perl Wisdom