All geek questions in one place

Perl module for writing excel2007 book

I have a huge report coming out of a tool from which I extract some important data and write an excel file. So far I have used the Spreadsheet :: WriteExcel module, but it crashed when the number of lines exceeded 65535. Is there any other module that supports creating excel for huge data? I checked in CPAN, found modules for reading excel2007 files, but could not find them for writing. I am not writing csv because I want to create multiple worksheets in an excel file.

+3
source share
2 answers

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

+9
source

If you checked the table link errors : WriteExcel cpan, you will notice that there is a defect that has been open for more than 11 months for this exact problem.

Error ID: 54902

However, can you instead try to write 65536 rows in each spreadsheet in chunks and assemble it later?

+3
source

Source: https://habr.com/ru/post/1795967/

More articles:


All Articles