Hi,
The number of sheets by itself (if not limited) does not
have a big impact on the size of the workbook, if each sheet
does not contain too much data.
Doing more testing with the setting I have, I can see that
the maximum number of sheets that
Spreadsheet::WriteExcel can create go upto 247 sheets, but
no more, without the resulting workbook
being empty. The resulting size is less than 3MB.
Really I doubt that Spreadsheet::WriteExcel explicitly limit
the number of sheets it can create.
The documentation states the/a solution to the "File
with a size of 0 Byte" issue, is to explicitly
close the workbook before exiting. Unfortunately doing this
does not fix the issue when wanting
to have more than 247 sheets.
Question: Are there any other work-around for the
"File with a size of 0 Byte" issue ?
TIA.
To write a respons, access
http://ww
w.cpanforum.com/response_form/2060
To see the full thread, access
http://www.cpan
forum.com/threads/2053
--
You are getting this messages from www.cpanforum.com
To change your subscription information visit http://www.cpanforum.
com/mypan/
|