Modules to work in excel

chn10db001 · 07-27-2011, 05:34 AM

Hi,

i need to format an excel worksheetlike adding borders, bold the headers, copying data from a flatfile and also need to add new excel worksheets using perl.

Kindly let me know what are all the modules i need to do the above activities.

Thanks

TB0ne · 07-27-2011, 09:16 AM

Quote:

Originally Posted by chn10db001

Hi,
i need to format an excel worksheetlike adding borders, bold the headers, copying data from a flatfile and also need to add new excel worksheets using perl.

Kindly let me know what are all the modules i need to do the above activities.
Thanks

If you go to CPAN and do a module search for Excel, you'll find them. Did you try?
http://search.cpan.org/search?query=excel&mode=all

There are many modules, some bigger than others, depending on what features you want. Look at them and determine what you need to do.