Fast Excel Plug-in

Overview

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.

Key Features & Functionality

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
• Supports MySQL and Oracle Database
• Header column colour can also be customised