which modules to be used..???

raaj has asked for the wisdom of the Perl Monks concerning the following question:

hi, i need to intract with excel file, i.e. to read and write in excel sheets which all are modules to be used in perl. and also please give me direction to download those modules in perl libraries. so that it should be work. Thanks in Advance.

Comment on which modules to be used..???

Replies are listed 'Best First'.
Re: which modules to be used..??? by Corion (Patriarch) on Mar 20, 2013 at 13:10 UTC
When you searched for Excel on CPAN, what modules did you find inacceptable? Also, in what way were the installation instructions as distributed with those modules confusing? My personal recommendation is to either use Win32::OLE and to automate Excel (see Using Win32::OLE and Excel - Tips and Tricks), or to use Spreadsheet::ParseExcel together with Spreadsheet::WriteExcel.	[reply]
Re: which modules to be used..??? by marto (Cardinal) on Mar 20, 2013 at 13:13 UTC
Depending on the contents of your Excel files Spreadsheet::ParseExcel::SaveParser (a combination of Spreadsheet::ParseExcel and Spreadsheet::WriteExcel, also worth familiarising yourself with) may be all you require. Note the "Known Problems". If on a Microsoft Windows platform you can use Win32::OLE to drive Excel, provided you have Excel installed. Failing that you can try to automate Libre/Openoffice on other platforms (see Re^5: Converting doc to txt without WIN32::OLE or search for more references).	[reply]