Changes for version 0.51

  • Speed optimisations.
    • This release contains a series of optimisations aimed at increasing the speed of Excel::Writer::XLSX. The overall improvement is around 66%. See the SPEED AND MEMORY USAGE section of the documentation.
  • Memory usage optimisations.
    • This fixes an issue where the memory used for the worksheet data tables was freed but then brought back into usage due to the use of an array as the base data structure. This meant that the memory usage still continued to grow with large row counts.
  • ! Added warning about Excel limit to 65,530 urls per worksheet.
  • ! Limit URLs to Excel's limit of 255 chars. Fixes Issue #26.
  • ! Fix for whitespace in urls. Fixes Issue #25.
  • ! Fix for solid fill of type 'none' is chart series. Closes issue #27 reported on Stack Overflow.
  • ! Modified write_array_formula() to apply format over full range. Fixes issue #18.
  • ! Fix for issue with chart formula referring to non-existent sheet name. It is now a fatal error to specify a chart series formula that refers to an non-existent worksheet name. Fixes issue #17.

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 Line charts.
A class for writing Excel Pie 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.
Light weight re-implementation of XML::Writer.
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