Changes for version v0.38.12 - 2015-08-19

  • Fix yet another bug in the hidden formatting (hopefully)
  • Make the decimal vs scientific choice for hidden formatting more robust( issue 65 on github )
  • Adding tests for hidden tabs rows columns and cells in the worksheet and cell
  • Adding the method 'get_merged_areas' to match ~::ParseExcel
  • For compatability purposes this package will now test (during import) to see if it's being used in Spreadsheet::Read (potential future) and automatically push the :like_ParseExcel tag on the end of the tag list so that it will behave consistently to ParseExcel for a common reader. (This is a beta feature and not guaranteed to remain)
  • This package now supports stacked flags (not that there exists so many already) The purpose of this is as I run into additional use cases the intersection of the flags I support and the flags that are desired by the user may require some juggling. Where flags disagree in their defaults the last flag passed will be used. This should allow for the proliferation of flags for specialty cases without having to explicitly build one for each use case. (At some point though you may just want to use the attributes). The test for this is t/Spreadsheet/XLSX/Reader/06-stacked_flags.t

Documentation

Read xlsx calcChain files with LibXML
Read xlsx chartsheets with LibXML
Read xlsx sharedStrings files with LibXML
Read xlsx styles files with LibXML
Read xlsx worksheets with LibXML

Modules

Read xlsx spreadsheet files with LibXML
Translate Excel cell IDs to column row
Moose class for remembering the last error
Default xlsx number formats and localization
Top level xlsx Worksheet interface
A type library for the LibXML xlsx reader
A LibXML::Reader xlsx base class
A LibXML::Reader calcChain base class
A LibXML::XMLReader chartsheet base class
A LibXML::Reader sharedStrings base class
A LibXML::Reader styles base class
A LibXML::XMLReader worksheet base class
XMLReader to turn xlsx XML to perl hashes