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

Changes for version 2.37

  • Added set_chartarea() and set_plotarea() methods to set chart and plot background colours and border lines.
  • ! Fixed bug where embedded charts gave "Data may be lost" warning. Reported by Andreas Strobitzer.
  • ! Fixed issue where set_properties() didn't work with ::Big. Marked ::Big as deprecated in the docs in favour of using Spreadsheet::WriteExcel directly. Removed WorkbookBig.pm.

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 writer class for Excel Area charts.
A writer class for Excel Bar charts.
A writer class for Excel Column charts.
A writer class for Excel external charts.
A writer class for Excel Line charts.
A writer class for Excel Pie charts.
A writer class for Excel Scatter charts.
A writer class for Excel Stock charts.
Spreadsheet::WriteExcel example programs.
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.
A module for creating Excel property sets.
Helper functions for Spreadsheet::WriteExcel.
A writer class for Excel Workbooks.
A writer class for Excel Worksheets.

Examples