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 color can also be customized

Parents

laurafp1648 1 month ago

Can this Smart Service be used to query an external database in SQLserver?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
jithesh 24 days ago in reply to laurafp1648

Yes.

1. External Database - As long as you configure the data source in admin console and pass in the jndi name it will work

2. SQLServer - Haven't tested specifically with SQLServer, but it should work as the implementation is generic. If you do see any errors or discrepancies in the output excel do update here and I will try to fix.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

jithesh 24 days ago in reply to laurafp1648

Yes.

1. External Database - As long as you configure the data source in admin console and pass in the jndi name it will work

2. SQLServer - Haven't tested specifically with SQLServer, but it should work as the implementation is generic. If you do see any errors or discrepancies in the output excel do update here and I will try to fix.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data