Changes for version 2.36

  • ! Fix for bug that gave a name conflict error for repeat rows and autofilters in some non-English versions of Excel. http://rt.cpan.org/Public/Bug/Display.html?id=38099
  • ! Fixed tab selection for Charts.
  • Added xl_range_formula() to Spreadsheet::WriteExcel::Utility to help with creating chart ranges. Added example to Chart docs.
  • Added set_legend() method with initial legend formatting options.
  • Documented Worksheet methods that are applicable to Charts.

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 Workbooks > 7MB.
A writer class for Excel Worksheets.

Examples