> -----Original Message----- > From: Peter Rabbitson [mailto:[EMAIL PROTECTED] > Sent: Friday, May 13, 2005 4:04 PM > To: beginners@perl.org > Subject: Create Excel spreadsheets > > > I am about to start on a project that will be creating > various excel files. > Cpan yields quite a number of posibilities, among which > Spreadsheet::WriteExcel looks most promising. I just wanted > to hear some > opinions on the best tool for the job before I delve into a certain > inetrface. > The resulting files must have multiple workbooks and be able > to contain > embedded images. The rest (numbers, text formatting) seems > trivial through > any interface. > All thoughts/suggestions appreciated. > > Peter >
Peter, I just finished a similar project... This link was VERY helpful... http://www-106.ibm.com/developerworks/linux/library/l-pexcel/ If you are using Windows you might try this.. use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; Hope this helps. Brian -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>