FAQ: Excel 2007+ file format and increased row and column limits

[jmcnamara]

Excel 2007+ uses a different file format from previous versions and
allows cell limits of 1,048,576 rows x 16,384 columns.

Spreadsheet::WriteExcel supports the older file format used in Excel <
2007 and cannot be extended to support these row limits. If you need
the larger row limits you should use the Excel::Writer::XLSX module:

http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX/lib/Excel/Writer/XLSX.pm

Excel::Writer::XLSX is a drop in replacement for
Spreadsheet::WriteExcel and has the advantage of supporting additional
functionality such as:

* Strings with multiple formats
* Conditional formatting
* Additional charting options
* Array formulas
* Formulas that reference external workbooks
* Third party functions.



John.
--