This library can help you to get some data read and written in Office Open XML xlsx format. Small subset of xlsx format is supported.

For examples look into Codec.Xlsx.

Format is covered by ECMA-376 standard: http://www.ecma-international.org/publications/standards/Ecma-376.htm

4th edition of the standard with the transitional schema is used for this library.

Changes

0.4.1

  • fixed serialization problem of empty validations and pivot caches (thanks laurent stephane [email protected] for reporting)

0.4.0

  • implemented basic charts support with only line charts currently
  • added data validation support (thanks Emil Axelsson [email protected])
  • fixed reading comments with empty author names (thanks Aleksey Khudyakov [email protected] for reporting)
  • implemented basic pivot table support
  • started using hindent to format library code

0.3.0

  • implemented number formats
  • fixed error of parsing “Default”s in content types (thanks Steve Bigham [email protected] for reporting)
  • fixed parsing workbooks with no shared strings (thanks Steve Bigham [email protected] for reporting)
  • changed the way sheets are stored to allow abitrary sheet order in a workbook
  • separated format information from other cell data in FormattedCell
  • implemented comment visibility (throught legacy vml drawings)

0.2.4

  • added basic images support
  • added “normal” cell formula support
  • added basic xlsx parsing error reporting (thanks to Brad Ediger [email protected])

0.2.3

  • added conditional formatting support
  • fixed reading empty subelements with defaults (thanks Steve Bigham [email protected])

0.2.2.2

  • fixed missing from parsing code font family value 0 (Not applicable) (thanks Steve Bigham [email protected])
  • fixed time type used in haddock example (thanks Manoj [email protected])

0.2.2.1

  • fixed comments data type names and modules/imports

0.2.2

  • added cell comments support
  • added custom file properties

0.2.1.2

  • loosened dependency on data-default package

0.2.1.1

  • fixed parsing shared string table entries with no content (thanks to Yuji Yamamoto [email protected])

0.2.1

  • added number formats (thanks to Alan Zimmerman [email protected])
  • loosened dependency on zip-archive package

0.2.0

0.1.2

  • added lenses to access cells both using RC and XY style coordinates, RC is used by default

0.1.1.1

  • fixed use of internal function for parsing shared strings, previous change was unused in practice

0.1.1

0.1.0.5

  • loosened dependency on zlib package

0.1.0.4

  • fixed generated xml so it gets read by MS Excel with no warnings (thanks Dmitriy Nikitinskiy [email protected])
  • improved shared strings collection by using Vector (thanks Dmitriy Nikitinskiy [email protected])
  • empty xml elements don’t get emmitted anymore (thanks Philipp Hausmann [email protected])
  • imporoved and cleaned up core.xml generation

0.1.0.3

  • added “str” cells content extraction as text
  • added a notice that formulas in are not yet supported

0.1.0

  • better tests and documentation
  • lenses for worksheets/cells
  • removed streaming support as it needs better API and improved implementaion
  • removed CellLocalTime as ambiguous, added CellBool

0.0.1

  • initial release