which modules to be used..???

[raaj]

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.

[Corion]

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.

[marto]

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).