Spurperl,

As others stated this seems to be a fix limit. However that buggered my programs up only when some sheet was spread onto two and the normally fixed count of worksheet contents was messed up. This is a pain but it may help that you can use as many spreadsheets as you like (well at least I am sure more than 106) but programming the graphics will be a real pain then if possible at all.

As for practical reasons if you do not need to apply any formatting in Excel later this Solution might work:
I only move data out of Excel. The Spreadsheet::ParseExcel and for file sizes that do not expand beyond sensible memory limits (20MB Excel file easily expand to 1GB of RAM) and have useable formatting. Otherwise use the OLE to get data out of Excel, which proves dead slow. Data is stored to XML, csv or sqlite. Graphics are done preferably with the Postscript::Simple module

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.