meir at guttman.co.il
Tue Mar 20 05:32:57 PDT 2012
> Does anyone have experience with this module?
> Can it be used to manipulate existing Excel files or only write new
On what platform do you want to *manipulate* the Excel sheet (as opposed to using MS Excel itself to eventually *open* it)?
If it is on WinNT/2000/xp/Vista/7 you can use Win32::OLE. With it you can read, change and write complete spreadsheets, including the creation of Formulas, conditional formatting and what not! It is essentially a Perl OLE interface, giving access to most Win-xxx application through mapping VBA functions to Perl.
> Best Regards,
> Dov Levenglick
More information about the Perl