I have used Spreadsheet::WriteExcel with some regualrity. It is a relatively simple module to get things done - especially when the Excel file to be generated is not complex.
 
I haven't fiddled with the SimpleExcel module ...
 
Spreadsheet::ReadExcel is a great module for parsing (simple) excel files as well.
 
Excel has become a fefacto standard for representing Spreadsheet data, so it's well worht your time to learn to use these modules if you ever have to represent any tablulated or structured data to other folks.
 
Regards


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Cornetet
Sent: Sunday, April 09, 2006 1:14 PM
To: [email protected]
Subject: RE: creating an excel file

If you don't need to put the data into an existing spreadsheet, and you don't need to do an special excel tricks, I find the easiest way is to just create an HTML table in a file, and give it a ".XLS" extension. Excel reads it and converts automatically. No modules need.


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sandeep Deshpande
Sent: Saturday, April 08, 2006 8:35 AM
To: [email protected]
Subject: RE: creating an excel file

You can also use Win32::OLE::Const 'Microsoft Excel'; and create/update MS-Excel files.

 

 

Thanks & Regards,

Sandeep Deshpande

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Eko Budiharto
Sent: Saturday, April 08, 2006 9:34 AM
To: [email protected]
Subject: creating an excel file

 

hi,

I would like to import some data from mysql and write into an excel file. Do you mind if you can tell me which module I can use to do that?

I read in the cpan.org, but I am not sure which one I should use.

There are Spreadsheet::WriteExcel , Spreadsheet::SimpleExcel and others.

 

I am looking forward to a favorable reply from you. Thank you.

 

Regards,

Eko.


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.

_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to