v2.12.1

#206 Fix typo in downloadFileFromQuery()

v2.12.0

• Add public createCellStyle() method
• Fix and improve handling of tab delimited data handling in csvToQuery()

v2.11.1

Bugfix for isHex regex

v2.11.0

Includes more control over data types when adding rows, and support for hex colour values.

v2.10.0

• Support for write encryption in ACF
• Improvements to addAutoFilter()
• Bug fixes with cell comment functionality

v2.9.0

Enhancements

• #186 Add option to formatting methods to preserve existing cell styles
• #184 Add support for DATETIME and DATETIME2 (MSSQL) database column types

Fixes

• #185 Time only values do not respect custom TIME format specifying fractions of a second Fixes

v2.8.0

Enhancements

• #181 Add "INT" to query column formats cast as numeric
• #179 Provide a list of all predefined colours available to formatting methods

Fixes

• #182 addInfo() not working with Streaming XLSX
• #178 Color index lookup is using a deprecated enum class

v2.7.0

POI 4.1.2 and Apache Commons CSV 1.8 upgrades

v2.6.0

• Enhancements
  #174 Add getColumnWidth() and getColumnWidthInPixels()
• Fixes
  #173 Specifying a custom DATETIME date format mask seems to have no effect
  #172 In ACF query column case and order is not preserved
  #171 Using autoSizeColumns with a Streaming XLSX workbook causes an exception

v2.5.0

#170 Upgrade POI to 4.1.1. Includes performance improvements while writing large xlsx files.
#169 Improve handling of clearly non-date values which Lucee will parse as dates far in the future