v4.2.1

#377 AddRows() should not convert empty values to zeros when they are in a numeric typed query column

v4.2.0

Allow datatype to be specified with addColumn()

v4.1.1

Maintenance

• #372 Upgrade POI to 5.3.0, commons-csv to 1.11.0 and excel-streaming-reader to 4.4.0

v4.1.0

Enhancements

• #369 Add moveSheet()
• #370 Add sheet position to sheetInfo() properties

v4.0.0

• Breaking changes

  • #325 Drop support for ACF2016
  • #359 Library should default to returning cached cell formula values instead of always recalculating

• Enhancements

  • #358 Allow control of whether to return cached or freshly calculated formula values
  • #354 Add getCellAddress() to return a cell's alphanumeric reference
  • #364 Support integer range validation
  • #356 Support date range validation
  • #363 Add option to allow New() to default to creating an XLSX (XML) spreadsheet object

v3.12.0

• #346 Add writeCsv()
• #349 Upgrade POI to 5.2.5
• #350 Upgrade excel-streaming-reader to 4.2.1

v3.11.1

#345 readCsv(): Commons CSV boolean options should default to true.

v3.11.0

• #340 Add readCsv() for large file/advanced csv processing
• #336 Add parallelization option to queryToCsv()
• #343 Improve performance of queryToCsv()

v3.10.0

• #334 Upgrade POI to 5.2.4 and excel-streaming-reader to 4.1.2
• #324 Upgrade Commons CSV to 1.10.0
• #331 Allow custom date formats to be set on an instance post-init()

v3.9.0

• #321 Add createJavaObject() to support creating POI and other objects from the bundled jars
• #323 Add basic support for conditional formatting