Large excel files in Excel::Writer::XLSX

rohit_raghu has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I'm trying to create a large excel file using the Excel::Writer::XLSX module, but the file stops writing in the middle and aborts. The same program works using Spreadsheet::WriteExcel, but I need the better charts features of the XLSX module.

Comment on Large excel files in Excel::Writer::XLSX

Replies are listed 'Best First'.
Re: Large excel files in Excel::Writer::XLSX by ww (Archbishop) on Jul 16, 2012 at 11:43 UTC
And your code shows that the error is the missing semi-colon.... Please, edit OP and add (inside code tags) your code. The Monastery's crystal ball is still out being resurfaced.	[reply]
Re: Large excel files in Excel::Writer::XLSX by jmcnamara (Monsignor) on Jul 16, 2012 at 17:56 UTC
Perhaps you are running out of memory and the process is getting killed. If so, see the following section of the Excel::Writer::XLSX documentation (SPEED AND MEMORY USAGE) and use `set_optimization()`. -- John.	[reply]
Re^2: Large excel files in Excel::Writer::XLSX by rohit_raghu (Acolyte) on Jul 17, 2012 at 08:03 UTC
thanks a lot. It worked. Really slow, but better late than never.	[reply]
Re: Large excel files in Excel::Writer::XLSX by aitap (Curate) on Jul 16, 2012 at 12:46 UTC
Can you please show us at least the error message you recieve? Sorry if my advice was wrong.	[reply]
Re^2: Large excel files in Excel::Writer::XLSX by rohit_raghu (Acolyte) on Jul 17, 2012 at 05:12 UTC
There is no error message. It just stops in the middle and exits, leaving me with an empty excel file.	[reply]