Click here to get back home

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

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Help:Generating multiple spreadsheets in MSExcel worksheet using perl?? prasenjit 10-17-2006
Posted by prasenjit on October 17, 2006, 11:37 am
Please log in for more thread options


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.


Posted by Jim Gibson on October 17, 2006, 1:27 pm
Please log in for more thread options



> 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.
>

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.

--
Jim Gibson

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Similar ThreadsPosted
SpreadSheet::Write Excel- Is there a way to set background color for entire worksheet? January 21, 2005, 12:56 pm
Module(s) for generating PDF files November 28, 2004, 8:56 am
Google Spreadsheets November 7, 2006, 8:31 am
Parsing OpenOffice Spreadsheets April 25, 2005, 7:23 pm
How to write into existing Excel Spreadsheets? July 13, 2004, 1:24 pm
Reading AND writing Excel spreadsheets April 30, 2005, 10:05 am
Storing multiple cookies June 9, 2007, 11:58 am
WWW::Mechanize module: multiple Select. July 13, 2004, 7:36 pm
multiple packages (modules) in the same file May 2, 2005, 3:53 pm
how to install multiple modules with one Makefile.PL July 2, 2008, 11:56 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap