<p>
Some background: Spreadsheet::WriteExcel creates a temporary
file for
each worksheet and workbook. This helps to greatly reduce
the amount
of memory required by S::WE and increases the speed
substantially.
</p>
<p>
<i>
Question: Is there a limitation in the number of sheet in a
single
workbook?
</i>
</p>
<p>
Not from Spreadsheet::WriteExcel. However, there is
generally a system
limit on the maximum number of open files and this will in
turn
impose a limit of the number of temporary files that the
module can
use. If a temporary file cannot be created then the module
falls back
to storing the data in memory. If you have warnings turned
on in your
program then you should see a warning message about this.
(Note: there is
also a memory limit in Excel as pointed out by Jason above
but that is
a separate issue).
</p>
<p>
<i>
Question: Does Spreadsheet-WriteExcel keeps those temporary
files
opened 'til the end.
</i>
</p>
<p>
Yes. S::WE needs to know the final size of each Worksheet
before it can merge them into a workbook.
</p>
<p>
<i>
Question: What may explain that the final workbook be empty
when *no*
error is detected by the both Spreadsheet-WriteExcel package
and my
Perl program?
</i>
</p>
<p>
I'd suspect that you've exceeded S::WE's 7MB limit. Again
"-w" or "use warnings" should
tell you if this is happening. Try using
Spreadsheet::WriteExcel::Big instead (just
change the use and new() statements in your program).
</p>
John.<br />
-- <br />
To write a respons, access
http://ww
w.cpanforum.com/response_form/2061
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/
|