The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 2.10

  • Added chart support via external templates. Added Chart.pm and add_chart_ext() method to Workbook object. Added /charts directory with examples and documentation
  • Added write_date_time() worksheet method for writing dates and times in Excel date format. Added date_time.pl example.
  • Added automatic Unicode handling via utf8 in perl 5.8 and later. Thanks Mark Fowler. Added several unicode_*.pl examples in different encodings. Thanks to Sean Burke for the sample encodings.
  • Added write_to_scalar.pl example in order to answer frequently asked question about writing an Excel file to a scalar.

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