perl module for writing excel2007 workbook

I have a huge report coming out of a tool from which i 开发者_Go百科extract the some important data and write a excel file. Till now i used the module Spreadsheet::WriteExcel, but it crashed when the number of rows exceed 65535. Is there any other module which supports generating excel for huge data? I checked in CPAN, found modules for reading excel2007 files but couldnt find one for writing. I am not writing a csv because, i want to generate multiple worksheets in the excel file.

Excel::Writer::XLSX is an API compatible replacement for Spreadsheet::WriteExcel that supports the Excel 2007 xlsx format and the increased row/column limits.

If you check the bugs link on the Spreadsheet::WriteExcel cpan site, you will notice there is an defect which is open for more than 11 months for this exact issue.

Bug ID: 54902

That said, can't you instead try writing in chunks of 65536 rows in each spreadsheet and later collate it?