Plug-in (Function & Smart Service)Free

Fast Excel

by Cognizant US

Description

This Smart Service can be used to generate Excel Document from SQL Query. This is an alternative to Smart Services using the Apache POI library. This plugin makes use of Fast-Excel open-source java library and can handle large data sets efficiently by optimising the memory utilisation during the generation of excel file.

Features

Data Types: SQLSheetData Smart Services: writeSQLToExcelV1

Features:

  • Generates multi-sheet excel based on CDT data input
  • Column Names are taken from SQL command results (Use column aliases)
  • Supports generation of Password Protected Excel File
  • Tested with MySQL, Maria DB and Oracle Database. Support others too as JDBC implementation is generic.
  • Header column colour can also be customised

Release notes

Fixed Log4j Vulnerabilities

Version history (3)

1.2.0

Updated column label retrieval to align with JDBC spec. Fixes issue caused after MariaDB 3.x connector change. Remains compatible with 2.x and other DB drivers.

1.1.1

Updated dependency to address known CVEs

1.1.0

Initial release

Resources