@hackage / xlsx

Simple and incomplete Excel file parser/writer

Latest1.3.0

Changelog

1.3.0

  • fix row/column rendering in comment shapes (thanks to Tom Ellis tom-github@jaguarpaw.co.uk for reporting)
  • support for monad of no return (thanks to Kevin Brubeck Unhammer unhammer@fsfe.org)
  • dropped support for GHC 9.2.* and 9.4.* and added support for GHC 9.10.* and 9.12.*

1.2.0

  • expose sheet state in stream parser (thanks to Benjamin McRae benjamin@supercede.com)
  • drop unnecessary n namespace from stream writer (thanks to Michael Schneider michael@m1-s.com)
  • add support support for writing multiple sheets with stream writer (thanks to Michael Schneider michael@m1-s.com)

1.1.4

  • fix the problem with leading slashes for comments, drawings and pivot tables (thanks to mindston mindston@eml.cc)

1.1.3

  • fixed compatibility with xml-conduit moving rsPretty into internal module
  • dropped support for GHC 9.0.* and added support for GHC 9.8.*

1.1.2

  • Strip leading slash from target paths in relations as the ECMA-376 spec requires (thanks to Luke Clifton lukec@themk.net)

1.1.1

  • dropped support for GHC 8.8.* and 8.10.* and added support for GHC 9.4.* and 9.6.*

1.1.0

1.0.0

  • Add support for streaming xlsx files
  • dropped support for GHC 8.4.* and 8.6.* and added support for GHC 9.2.*
  • Treat 1900 as a leap year like Excel does

0.8.4

  • dropped support for GHC 8.0.* and 8.2.* and added support for GHC 8.10.* and 9.0.*

0.8.3

  • compatibility with lens-5.0
  • don't output lists with no elements in stylesheet as it causes problems in Excel (thanks to David Hewson david.hewson@tracsis.com)

0.8.2

0.8.1

  • compatibility with smallcheck-1.2.0

0.8.0

  • GHC 8.8 compatibility added (GHC 8.6 didn't need any updates). Dropped compatilibity with GHC 7.10 (thanks to David Hewson david.hewson@tracsis.com)

0.7.2

  • GHC 8.4 compatibility

0.7.1

  • improved compatibility with Excel in pivot cache serialization
  • added support for character references in fast parsing with xeno

0.7.0

  • fixed serialization of large integer values (thanks Radoslav Dorcik dixiecko@gmail.com)
  • added fast xlsx parsing using xeno library
  • dropped support for GHC 7.8.4 and added support for GHC 8.2.2
  • added numer format support in differential formatting records (thanks Emil Axelsson emax@chalmers.se)
  • added inlineStr cell type support
  • added shared formulas support
  • added error values support
  • helper functions for serialization/deserialization of date values (thanks José Romildo Malaquias malaquias@gmail.com)

0.6.0

0.5.0

  • renamed ColumnsWidth to more intuitive ColumnsProperties and added some more fields to it
  • added pivot table field sorting and hidden values support
  • added support for 4 more chart types

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 laurent_step@yahoo.fr for reporting)
  • fixed parsing cells with comments but with no content (thanks Stéphane Laurent laurent_step@yahoo.fr 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 laurent_step@yahoo.fr for reporting)
  • fixed problem of cwStyle not being optional (thanks laurent stephane laurent_step@yahoo.fr for reporting)
  • added basic autofilter support

0.4.1

  • fixed serialization problem of empty validations and pivot caches (thanks laurent stephane laurent_step@yahoo.fr for reporting)

0.4.0

  • implemented basic charts support with only line charts currently
  • added data validation support (thanks Emil Axelsson emax@chalmers.se)
  • fixed reading comments with empty author names (thanks Aleksey Khudyakov alexey.skladnoy@gmail.com 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 steve.bigham@gmail.com for reporting)
  • fixed parsing workbooks with no shared strings (thanks Steve Bigham steve.bigham@gmail.com 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 brad.ediger@madriska.com)

0.2.3

  • added conditional formatting support
  • fixed reading empty subelements with defaults (thanks Steve Bigham steve.bigham@gmail.com)
    • 0.2.2.2

      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

      0.2.1

      • added number formats (thanks to Alan Zimmerman alan.zimm@gmail.com)
      • 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 nikitinskiy@gmail.com)
      • improved shared strings collection by using Vector (thanks Dmitriy Nikitinskiy nikitinskiy@gmail.com)
      • empty xml elements don't get emmitted anymore (thanks Philipp Hausmann nikitinskiy@gmail.com)
      • 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