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
Features:
Any reason this hasn't been configured to accept a Base Template? Or if it has, where is the option in the config screenshot?
Unfortunately it doesn't support using a Base Template/Editing an existing excel. This plugin makes use of Fast Excel java library to perform memory efficient excel generation. And this library is designed to write workbooks from scratch.
Gotcha - sadly that makes this plug-in nearly useless for me, as every customer report i've ever developed (for instance) has needed to go onto a pre-formatted and friendly-looking base template with things like custom header rows preformatted and preformatted column widths.