Changes for version 2.20

  • Added autofilter() and filter_column() method and autofilter.pl example.
  • Added embed_chart() method to allow extracted chart templates to be embedded in a worksheet. Added demo4.pl and demo5.pl examples.
  • Added the insert_image() method and proper Excel 97 style image handling for PNG and BMP. Images now work with Gnumeric and OpenOffice. insert_bitmap() is now deprecated.
  • ! Made pane split optional when calling freeze_panes(). Also renamed thaw_panes() as split_panes(). The old method name is still available, but deprected..
  • ! Renamed write_unicode() and write_unicode_le() methods to the more explicit write_utf16be_string() and write_utf16le_string(). The old method names are still available, but deprected.

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