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
Can you check if you are passing semi-colon in the sqlQuery? It should not be included.
I tried to pass 4 sheets and 4 query rules(same statement). I am getting [SQL command not properly ended] error. Is there any specification to consider while writing sql statement. I was able to get document for one sheet. For multiple sheet I am getting this error.
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.
Any limitation on data volum or number of columns
I am looking for 40+mb data with 140 coloumns.