Home: Perl Programming Help: Intermediate:
Access Excel file from perl with MS Excel installation



venkat.spark
New User

Jul 20, 2009, 3:25 AM


Views: 975
Access Excel file from perl with MS Excel installation

i have a perl script which takes the inputs from the Excel file and writes to a excel file. i need this script to work on a test machine where MS-Office is not installed.

Can we have a way to acheive this?


Thanks
Venkat


FishMonger
Veteran / Moderator

Jul 20, 2009, 9:23 AM


Views: 972
Re: [venkat.spark] Access Excel file from perl with MS Excel installation

Spreadsheet::ParseExcel - Extract information from an Excel file
http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.49/lib/Spreadsheet/ParseExcel.pm

Spreadsheet::WriteExcel - Write to a cross-platform Excel binary file.
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.25/lib/Spreadsheet/WriteExcel.pm


venkat.spark
New User

Jul 21, 2009, 11:57 PM


Views: 958
Re: [FishMonger] Access Excel file from perl with MS Excel installation

Thanks for the reply.

with the modules i could able to write the excel sheet "perl.xls" and read the same excel sheet "perl.xls".

But for some other excel sheet like "input.xls" which i created in other machine and copied to the current machine, the module could not able to read the excel sheet.

Thanks in advance,
Venkat