Workbook limitations - CPAN::Forum

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

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.