v5.3.0

• #445 Upgrade POI to 5.5.1 and Excel Streaming Reader to 5.2.0
• #444 ReadCSV(): add option to return a query object

v5.2.1

#441 Upgrade POI to 5.5.0

v5.2.0

Enhancements

• #429 Allow info() to read a password protected file
• #433 Data validation: support minimum or maximum date or integer values
• #434 Data validation: allow integer and date inputs to accept a formula
• #435 Data validation: support decimal min/max/range constraints
• #436 Data validation: support text length constraint
• #437 Data validation: support custom constraints using formula
• #438 Data validation: Allow the 'Ignore blanks' or 'Allow empty cells' flag to be turned off

Fixes

• #426 Read() not importing trailing empty columns when headerRow and rows arguments specified

v5.1.0

Enhancements

• #424 Allow read() to return an array
• #425 Allow read() to return an array of structs
• #423 readCSV(): remove any BOM from the input file so it is not part of the first row

v5.0.0

Breaking changes

• #421 Drop support for Adobe ColdFusion 2018
• #419 Formula errors no longer cause an exception or return an empty string by default
• #416 Remove requiresJavaLoader property

Enhancements

• #417 Allow the library jars to be loaded explicitly via application "javaSettings" instead of OSGi or JavaLoader

Fixes

• #420 Fix celltype check on Mac

v4.8.0

Enhancements

• #412 ReadCSV(): Pass column names to row processor and filter UDFs
• #413 ReadCSV(): provide option to process rows as CFML arrays instead of java arrays
• #414 ProcessLargeFile(): Pass header row as columns argument to rowProcessor

v4.7.0

• Enhancements

  • #397 Support Adobe ColdFusion 2025
  • #395 Add support for column/row grouping
  • #407 Add row/column group collapsing and expansion
  • #396 Add support for column/row breaks
  • #398 Add getActiveCell()
  • #403 Add recalculateAllFormulas() to update cached values
  • #408 Add getSheetPrintOrientation()
  • #409 Add getRecalculateFormulasOnNextOpen()
  • #410 Add printOrientation to sheetInfo() properties
  • #411 Allow setRecalculateFormulasOnNextOpen() on a specific sheet

• Maintenance

  • #404 Upgrade POI to 5.4.1
  • #405 Upgrade Excel Streaming Reader to 5.0.4
  • #406 Upgrade Commons CSV to 1.14.0

v4.6.1

• #399 hideSheet() and unhideSheet() should not require the sheet to be specified, and default to the currently active sheet
• #400 Allow hideSheet() and unhideSheet() to specify the sheet number positionally

v4.6.0

#394 Add hideSheet() and unhideSheet()

v4.5.0

#392 Add processLargeFile() to process large XLSX files without reading the entire data into memory