Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^2: Out of memory problem in Windows XP 32-bit: only 1GB occupied

by dasgar (Priest)
on Feb 01, 2013 at 14:21 UTC ( [id://1016563]=note: print w/replies, xml ) Need Help??


in reply to Re: Out of memory problem in Windows XP 32-bit: only 1GB occupied
in thread Out of memory problem in Windows XP 32-bit: only 1GB occupied

Outside of your script, are there plans for a user to open this Excel spreadsheet using Excel? If so, you may be close to or exceeding the max number of rows for a worksheet depending on which version of Excel that you're using.

Pulling up the help in my Excel 2010, I found the following information:

"In Excel 2010 and Excel 2007, the worksheet size is 16,384 columns by 1,048,576 rows, but the worksheet size of Excel 97-2003 is only 256 columns by 65,536 rows. Data in cells outside of this column and row limit is lost in Excel 97-2003."

If there's any potential for the number of rows to significantly increase, it sounds like you'll have issues opening the file in Excel. Just wanted to point out this limitation that your exceeding (Excel 97-2003) or getting close to exceeding (Excel 2007, 2010).

  • Comment on Re^2: Out of memory problem in Windows XP 32-bit: only 1GB occupied

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1016563]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (7)
As of 2024-04-23 20:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found