Changes for version 0.82

  • Added extra documentation on how to handle VBA macros and added automatic and manual setting of workbook and worksheet VBA codenames. Issue #60.
  • Fix for set_start_page() for values > 1.
  • Fix to copy user defined chart properties, such as trendlines, so that they aren't overwritten. Issue #121.
  • Added column funtion_value option to add_table to allow function value to be set.
  • Allow explicit text categories in charts. Issue #102
  • Fix for column/bar gap/overlap on y2 axis. Issue #113.

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 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