Changes for version 1.12 - 2024-02-26

  • Added support for embedding images into worksheets with worksheet `embed_image()`.
    • This can be useful if you are building up a spreadsheet of products with a column of images for each product. Embedded images move with the cell so they can be used in worksheet tables or data ranges that will be sorted or filtered.
    • This functionality is the equivalent of Excel's menu option to insert an image using the option to "Place in Cell" which is available in Excel 365 versions from 2023 onwards.
  • Added support for Excel 365 `IMAGE()` future.
  • Added trendline equation formatting for Charts.
  • Added support for leader lines to all chart types.
  • Added chart option to display `N/A` as empty cells.
  • Add support for `invert_if_negative` color option in Charts.
  • Added worksheet `very_hidden()` method to hide a worksheet in a way that it can only be unhidden by VBA. Feature Request #228.
  • ! Fixed identation and alignment property mismatch.
    • Fix issue where a horizontal alignment format was ignored if the indentation was also set.

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 RichValue file.
A class for writing the Excel XLSX richValueRel.xml file.
A class for writing the Excel XLSX rdrichvaluestructure.xml file.
A class for writing the Excel XLSX rdRichValueTypes.xml 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