List Info

Thread: Maximum number of sheets.




Maximum number of sheets.
user name
2006-03-29 17:09:06
Hi,


First I had to use Spreadsheet::WriteExcel::Big otherwise
the script was failing,
That is, above a certain number of sheets, whatever their
size one need to use the Big version
of S::WE.

I also set the maximum number of iterations to 2048 instead
of '1025'.

Unfortunately, S::WE did not complain. It accepted all of
our requests, that is, creating 2048 
sheets. The resulting workbook was desperately *empty* :( .
Also no warning was generated.

So I decided to find the maximum number of sheets below
which the resulting file is empty.

The result being that as soon as you are above 250
iterations (sheets), the 'multi.xls' become
empty. An absolutely no warning is generated.

That is, for 251 sheets to 2048 sheets (and more) the
resulting workbook is empty (no warning).


Here are the other information you requested:

OS version:
  SunOS 5.8 sun4u sparc SUNW,Ultra-5_10 Solaris

Perl version:
  v5.8.3 built for sun4-solaris-thread-multi
  

HTH.

To write a respons, access
http://ww
w.cpanforum.com/response_form/2069

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/

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )