[Israel.pm] Spreadsheet::WriteExcel

Meir Guttman meir at guttman.co.il
Tue Mar 20 05:32:57 PDT 2012


Dear Dov,

> 
> Does anyone have experience with this module?
> Can it be used to manipulate existing Excel files or only write new
> ones?
> 

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


Regards,
Meir




More information about the Perl mailing list