The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
Excel-Writer-XLSX-1.08
River stage two • 26 direct dependents • 33 total dependents
64 ++

Changes for version 1.08 - 2021-03-31

  • Added ability to add accessibility options "description" and "decorative" to images via insert_image().
  • Added the workbook read_only_recommended() method to set the Excel "Read-only Recommended" option that is available when saving a file.
  • Added option to set a chart crossing to 'min' as well as the existing 'max' option. The 'min' option isn't available in the Excel interface but can be enabled via VBA.
  • Added option to unprotect ranges in protected worksheets.
  • Added check, and warning, for worksheet tables with no data row. Either with or without a header row.
  • Added ignore_errors() worksheet method to ignore Excel worksheet errors/warnings in user defined ranges.
  • ! Fixed issue where pattern formats without colours where given a default black fill colour.
  • ! Fix issue where custom chart data labels didn't inherit the position for the data labels in the series.
  • ! Fixed issue with relative url links in images.
  • ! Fixed issue where headers/footers were restricted to 254 characters instead of 255.

Documentation

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

Modules

Excel::Writer::XLSX
Create a new file in the Excel 2007+ XLSX format.
Excel::Writer::XLSX::Chart
A class for writing Excel Charts.
Excel::Writer::XLSX::Chart::Area
A class for writing Excel Area charts.
Excel::Writer::XLSX::Chart::Bar
A class for writing Excel Bar charts.
Excel::Writer::XLSX::Chart::Column
A class for writing Excel Column charts.
Excel::Writer::XLSX::Chart::Doughnut
A class for writing Excel Doughnut charts.
Excel::Writer::XLSX::Chart::Line
A class for writing Excel Line charts.
Excel::Writer::XLSX::Chart::Pie
A class for writing Excel Pie charts.
Excel::Writer::XLSX::Chart::Radar
A class for writing Excel Radar charts.
Excel::Writer::XLSX::Chart::Scatter
A class for writing Excel Scatter charts.
Excel::Writer::XLSX::Chart::Stock
A class for writing Excel Stock charts.
Excel::Writer::XLSX::Chartsheet
A class for writing the Excel XLSX Chartsheet files.
Excel::Writer::XLSX::Drawing
A class for writing the Excel XLSX drawing.xml file.
Excel::Writer::XLSX::Examples
Excel::Writer::XLSX example programs.
Excel::Writer::XLSX::Format
A class for defining Excel formatting.
Excel::Writer::XLSX::Package::App
A class for writing the Excel XLSX app.xml file.
Excel::Writer::XLSX::Package::Comments
A class for writing the Excel XLSX Comments files.
Excel::Writer::XLSX::Package::ContentTypes
A class for writing the Excel XLSX [Content_Types] file.
Excel::Writer::XLSX::Package::Core
A class for writing the Excel XLSX core.xml file.
Excel::Writer::XLSX::Package::Custom
A class for writing the Excel XLSX custom.xml file.
Excel::Writer::XLSX::Package::Packager
A class for creating the Excel XLSX package.
Excel::Writer::XLSX::Package::Relationships
A class for writing the Excel XLSX Rels file.
Excel::Writer::XLSX::Package::SharedStrings
A class for writing the Excel XLSX sharedStrings.xml file.
Excel::Writer::XLSX::Package::Styles
A class for writing the Excel XLSX styles file.
Excel::Writer::XLSX::Package::Table
A class for writing the Excel XLSX Table file.
Excel::Writer::XLSX::Package::Theme
A class for writing the Excel XLSX Theme file.
Excel::Writer::XLSX::Package::VML
A class for writing the Excel XLSX VML files.
Excel::Writer::XLSX::Package::XMLwriter
A base class for the Excel::Writer::XLSX writer classes.
Excel::Writer::XLSX::Shape
A class for creating Excel Drawing shapes
Excel::Writer::XLSX::Utility
Helper functions for Excel::Writer::XLSX.
Excel::Writer::XLSX::Workbook
A class for writing Excel Workbooks.
Excel::Writer::XLSX::Worksheet
A class for writing Excel Worksheets.

Examples

Other files