Help:Generating multiple spreadsheets in MSExcel worksheet using perl??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prasenjit - 17 Oct 2006 16:37 GMT

Hi,
I am facing a problem in which i want to create a MSExcel worksheet in
which i need to have multiple spreadsheets.
Another issue regarding this, which is not on higher priority, is that,

The data should be taken from an existing file and imported to the
worksheet in which it will be further divided into seperate
spreedsheets.
Please suggest how to create the worksheet consisting of multiple
spreadsheets in it.

Reply to this Message

Jim Gibson - 17 Oct 2006 18:27 GMT

> Hi,
> I am facing a problem in which i want to create a MSExcel worksheet in
[quoted text clipped - 6 lines]
> Please suggest how to create the worksheet consisting of multiple
> spreadsheets in it.

Use the Spreadsheet::WriteExcel module, available from www.cpan.org.

This module may be used to create an Excel "workbook" with one or more
"worksheets", if that is what you want. That is Microsoft's
terminology, although it differs from what you have requested.

Signature

Jim Gibson

Reply to this Message

Webmaster Forum / Perl / Modules / October 2006

Help:Generating multiple spreadsheets in MSExcel worksheet using perl??