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

Changes for version 2.21

  • ! Fixed bug where UTF-8 strings in formulas weren't handled. Thanks Sergey Zhuravlev. http://rt.cpan.org/Public/Bug/Display.html?id=30368
  • ! Fixed collapse outlines compatibility with Gnumeric and OpenOffice.org. Reported by Barrie Slaymaker. http://rt.cpan.org/Public/Bug/Display.html?id=33662
  • Added outline_collapsed.pl example.
  • Added document section about rewriting Excel files.
  • Minor security fix to Format to avoid eval and additional fix for RT 24218. Thanks to Bram.
  • Added increased compatibility with third party Excel reading applications such as POI.
  • Added optional compatibility_mode() to fix problems that can occur with Office SP3.
  • Fixed compatibility problem with Google Docs.
  • Added set_start_page() method for setting the start page number when printing.

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