I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Spreadsheet-WriteExcel
Posted on 2009-12-08 12:47:04-08 by ramchandar
Workbook limitations
I am on a project, in which exporting data into multiple worksheets into a single workbook. Each work sheet will have data in all 65,536 rows (excel limit), in such scenario how many worksheets with huge number records in all rows can be inserted and exported.
Direct Responses: 11894 | Write a response
Posted on 2009-12-08 16:07:27-08 by jmcnamara in response to 11890
Re: Workbook limitations

It depends on a number of variables. For instance, the amount of unique strings that are written and the amount of memory available on the system. The best solution is to test it.

For a solution like this see the row_wrap.pl program in the examples directory of the Spreadsheet::WriteExcel distro.

If you have a followup question please post it to the Spreadsheet::WriteExcel Google group:

John.
--
Direct Responses: Write a response