Changes for version 2.01
- This version is a MAJOR revs ion to Spreadsheet::WriteExcel. The format of the Excel file that it produces has been updated from Excel 5 to Excel 97. This allows support for long, 32k character strings and Unicode.
- DUE TO THE MAJOR INTERNAL CHANGES IT IS RECOMMENDED THAT YOU TEST THIS UPGRADE FULLY BEFORE DEPLOYING IT.
- Also note that this version can be 1.5 to 2 times slower than previous versions and the write_comment() method has been temporarily removed. These issues will be fixed in later releases.
- Changed the default Excel format to Excel 97.
- Added support for strings up to 32767 character.
- Added support for Unicode strings.
- Improved speed in relation to pre-release versions. However, it is still slower than the 1.xx versions.
- Improved OpenOffice support.
- Added more examples: diag_border.pl, indent.pl, unicode.pl, unicode_japan.pl, unicode_list.pl
- Changed the distro dir structure.
- Temporarily removed write_comment() support since the Excel 5 version isn't compatible with Excel 97+.
Modules
Write to a cross-platform Excel binary file.
An abstract base class for Excel workbooks and worksheets.
A class for creating Excel files > 7MB.
A class for defining Excel formatting.
A class for generating Excel formulas
A writer class to store BIFF data in a OLE compound storage file.
Helper functions for Spreadsheet::WriteExcel.
A writer class for Excel Workbooks.
A writer class for Excel Workbooks > 7MB.
A writer class for Excel Worksheets.
Examples
- doc/examples.html
- examples/README
- examples/bigfile.pl
- examples/bug_report.pl
- examples/cgi.pl
- examples/chess.pl
- examples/colors.pl
- examples/convertA1.pl
- examples/copyformat.pl
- examples/csv2xls.pl
- examples/datecalc1.pl
- examples/datecalc2.pl
- examples/demo.pl
- examples/diag_border.pl
- examples/easter_egg.pl
- examples/filehandle.pl
- examples/formats.pl
- examples/function_locale.pl
- examples/headers.pl
- examples/hyperlink1.pl
- examples/hyperlink2.pl
- examples/images.pl
- examples/indent.pl
- examples/lecxe.pl
- examples/merge1.pl
- examples/merge2.pl
- examples/merge3.pl
- examples/merge4.pl
- examples/merge5.pl
- examples/mod_perl.pl
- examples/outline.pl
- examples/panes.pl
- examples/protection.pl
- examples/regions.pl
- examples/repeat.pl
- examples/republic.bmp
- examples/sales.pl
- examples/sendmail.pl
- examples/simple.pl
- examples/stats.pl
- examples/stats_ext.pl
- examples/stocks.pl
- examples/tab2xls.pl
- examples/textwrap.pl
- examples/unicode.pl
- examples/unicode_japan.pl
- examples/unicode_list.pl
- examples/win32ole.pl
- examples/writeA1.pl
- examples/write_arrays.pl
- examples/writemany.pl