xlsx

Simple and incomplete Excel file parser/writer https://github.com/qrilka/xlsx

Version on this page:0.1.1
LTS Haskell 8.6:0.4.3
Stackage Nightly 2017-03-30:0.4.3
Latest on Hackage:0.4.3
MIT licensed by Tim, Max, Kirill Zaborsky

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.3

  • added (legacy) sheet protection support
  • switched to use r prefix for relationships namespace in workbook.xml to improve compatibility with readers expecting that prefix (thanks St├ęphane Laurent for reporting)
  • fixed parsing cells with comments but with no content (thanks St├ęphane Laurent for reporting)
  • added some higher-level helpers work with pictures in SpreadsheetML Drawing

0.4.2

  • added basic tables support
  • fixed boolean element parsing for rich text run properties (thanks laurent stephane for reporting)
  • fixed problem of cwStyle not being optional (thanks laurent stephane for reporting)
  • added basic autofilter support

0.4.1

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

0.4.0

  • implemented basic charts support with only line charts currently
  • added data validation support (thanks Emil Axelsson )
  • fixed reading comments with empty author names (thanks Aleksey Khudyakov 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 for reporting)
  • fixed parsing workbooks with no shared strings (thanks Steve Bigham 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 )

0.2.3

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

0.2.2.2

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

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 )

0.2.1

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

0.2.0

  • added style sheet support (thanks to Edsko de Vries )
  • added high level interface for styling (thanks to Edsko de Vries )
  • added sheet views support (thanks to Edsko de Vries )
  • added page setup support (thanks to Edsko de Vries )
  • switched from System.Time to Data.Time
  • added rich text support (thanks to Edsko de Vries ) including shared strings
  • added a bit better internals for rendering (thanks to Edsko de Vries ) and parsing

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

  • added support for rich text shared strings (thanks to Steve Bigham )

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 )
  • improved shared strings collection by using Vector (thanks Dmitriy Nikitinskiy )
  • empty xml elements don't get emmitted anymore (thanks Philipp Hausmann )
  • 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
comments powered byDisqus