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

Changes for version 2.15

  • ! Changed OLE container stream name from "Book" to "Workbook" for compatibility with some third party apps.
  • Thanks Wieland Pusch and Kevin McMahon.
    • ! Fixed bug that caused all worksheets to be selected in OpenOfficeOrg causing strange linking of data between Worksheets. Thanks M. Brodbelt. See http://rt.cpan.org/NoAuth/Bug.html?id=14094 http://www.openoffice.org/issues/show_bug.cgi?id=52955
    • ! Changed file creation from end of program to the start of program in order to avoid race conditions and extra file creation on VMS.
  • Added optional user supplied results for formulas as a workaround for uncalcuated values in some non-Excel apps. Added formula_result.pl example of above.

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