Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WriteExcel error message - file too big

Status
Not open for further replies.

Paul12345671

Technical User
Dec 3, 2006
15
AU
Hello,
I'm using Spreadsheet::WriteExcel to create a large Excel Spreadsheet. However, I get the error message: Maximum Spreadsheet:WriteExcel filesize, 7087104 bytes, exceeded. To create files bigger than this limite please install OLE:Storage_Lite.

I have Perl (v 5.12.2), Spreadsheet-WriteExcel (2.37) and OLE-Storage_Lite (0.19) installed according to PPM.

Does anyone know how I can overcome this error message?

Thank you,

Paul.
 
Hi Paul.

If you're using Spreadsheet::WriteExcel prior to version 2.17, you will get this problem with files larger than about 7 Meg. In that case, you need to install Spreadsheet::WriteExcel::Big.

But that is now deprecated, so a better way is to install a newer version of Spreadsheet::WriteExcel. Current version is 2.37. That won't have this problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top