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: SQLSheetDataSmart Services: writeSQLToExcelV1
Any limitation on data volum or number of columns
I am looking for 40+mb data with 140 coloumns.
No there is no limit. Your requirement should be handled fine.
To highlight it has been perf tested for 100 concurrent invocations, each generating ~10 sheets, with ~50-100K Rows on each sheet, each file size 30~50Mb.
The plugin manages memory efficiently by doing frequent flush to file, only 100 rows are in memory at any time. So you are unlikely to hit out of memory no matter the size of data.