用于编写excel2007工作簿的perl模块(perl module for writing excel2007 workbook)

用于编写excel2007工作簿的perl模块(perl module for writing excel2007 workbook)

我有一个巨大的报告来自一个工具，我从中提取一些重要的数据并编写一个excel文件。 到目前为止，我使用了Spreadsheet :: WriteExcel模块，但是当行数超过65535时，它崩溃了。有没有其他模块支持为大数据生成excel？ 我检查了CPAN，发现读取excel2007文件的模块，但没有找到一个写作。 我不写一个csv，因为我想在excel文件中生成多个工作表。

I have a huge report coming out of a tool from which i 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是一个支持Excel 2007 xlsx格式和增加的行/列限制的Spreadsheet :: WriteExcel的API兼容替代品。

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