which module to use?

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

Dear Monks:
I am confuse, I am working on a project that it gives you a CSV file and I need it to turn it into a excel file, so far so good, but now I need to modify the excel file, to add totals, and graphics, and other things like give it an autoformat.
looking I found Spreadsheet::WriteExcel but on the cpan docs it's says that these is for only NEW documents not for already done documents.
so whish module should I use ????

Comment on which module to use?

Replies are listed 'Best First'.
Re: which module to use? by Corion (Patriarch) on Jan 11, 2008 at 19:30 UTC
I use Win32::OLE for that (and the Excel Macro Recorder, to find out the functions to call in the API)	[reply]
Re^2: which module to use? by ArmandoG (Sexton) on Jan 11, 2008 at 19:34 UTC
I am afraid I did not understand, Excel Macro Recorder? are not all the functions that i need in one module? Thanks	[reply]
Re^3: which module to use? by Corion (Patriarch) on Jan 11, 2008 at 19:39 UTC
No - Win32::OLE is incredibly convenient for automating Microsoft Excel and many other Windows programs. You can try Spreadsheet::ParseExcel in conjunction with SpreadSheet::WriteExcel and Excel::Template, but I'm sure you found these already via CPAN.	[reply]
Re^4: which module to use? by ArmandoG (Sexton) on Jan 11, 2008 at 19:53 UTC
Re^5: which module to use? by Corion (Patriarch) on Jan 11, 2008 at 20:03 UTC
Re: which module to use? by Anonymous Monk on Jan 12, 2008 at 06:40 UTC
Hi, Alternatively, you could use Spreadsheet::WriteExcel to format the CSV data into the formatted excel file all in one go. I found the documentation fairly easy to understand, and the results impressed the people I work with. It's worth a look. J.C.	[reply]