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

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

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

venkat.spark
New User

Jul 20, 2009, 3:25 AM

Post #1 of 3 (574 views)

Access Excel file from perl with MS Excel installation	Can't Post

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

Jul 20, 2009, 9:23 AM

Post #2 of 3 (571 views)

Re: [venkat.spark] Access Excel file from perl with MS Excel installation [In reply to]	Can't Post

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

Post #3 of 3 (557 views)

Re: [FishMonger] Access Excel file from perl with MS Excel installation [In reply to]	Can't Post

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

Search for (options)

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives