The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

Changes for version 1.11 - 2023-03-19

  • Added support for simulated worksheet `autofit()`.
  • Refactored internal column property handling to allow column ranges to be overridden (a common UX expectation).
  • Add `quote_prefix` format property.
  • ! Add fix for forward/backward slash issue on Windows perl builds. Possibly introduced by a change in File::Find. Issue #284
  • ! Fix for duplicate number formats. Issue #283
  • ! Add fix for worksheets with tables and background images.
  • ! Replace/fix the worksheet protection password algorithm so that is works correctly for strings over 24 chars.

Documentation

A utility to extract a VBA project from an Excel 2007+ xlsm file.

Modules

Create a new file in the Excel 2007+ XLSX format.
A class for writing Excel Charts.
A class for writing Excel Area charts.
A class for writing Excel Bar charts.
A class for writing Excel Column charts.
A class for writing Excel Doughnut charts.
A class for writing Excel Line charts.
A class for writing Excel Pie charts.
A class for writing Excel Radar charts.
A class for writing Excel Scatter charts.
A class for writing Excel Stock charts.
A class for writing the Excel XLSX Chartsheet files.
A class for writing the Excel XLSX drawing.xml file.
Excel::Writer::XLSX example programs.
A class for defining Excel formatting.
A class for writing the Excel XLSX app.xml file.
A class for writing the Excel XLSX Comments files.
A class for writing the Excel XLSX [Content_Types] file.
A class for writing the Excel XLSX core.xml file.
A class for writing the Excel XLSX custom.xml file.
A class for writing the Excel XLSX metadata.xml file.
A class for creating the Excel XLSX package.
A class for writing the Excel XLSX Rels file.
A class for writing the Excel XLSX sharedStrings.xml file.
A class for writing the Excel XLSX styles file.
A class for writing the Excel XLSX Table file.
A class for writing the Excel XLSX Theme file.
A class for writing the Excel XLSX VML files.
A base class for the Excel::Writer::XLSX writer classes.
A class for creating Excel Drawing shapes
Helper functions for Excel::Writer::XLSX.
A class for writing Excel Workbooks.
A class for writing Excel Worksheets.

Examples