Changes for version 2.18

  • ! Correct invalid user set_column() calls to prevent crashes after Excel patch KB918419 is applied. Thanks to Sharron McKenzie for debugging.
  • ! Fixed bug when writing comments longer than 8219 bytes. Reported by jscaglione.
  • ! Fixed bug when using copy() with merged formats. Reported by jscaglione.
  • ! Fixed bug where $@ was clobbered during garbage collection. Reported by afoxson. http://rt.cpan.org/Public/Bug/Display.html?id=24218
  • ! Removed all non-ascii characters from main docs to avoid problems with troff and man. Reported by Ken Williams. http://rt.cpan.org/Public/Bug/Display.html?id=20948
  • Added autoloading of OLE::Storage_Lite, when available, to create workbooks larger than 7MB. It is no longer required to explicitly use ::Big.
  • Added handling of Unicode sheet names in formulas as suggested by Zhur: http://rt.cpan.org/Public/Bug/Display.html?id=20059

Documentation

A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.
A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.

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 writer class for Excel Charts.
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