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:
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.
Any reason this hasn't been configured to accept a Base Template? Or if it has, where is the option in the config screenshot?
Thanks for highlighting the issue. Looks like its due to a change in SQL driver in the new Appian env. Will release a fix for this by end of this week.
Issue with this plugin after Appian upgrade to 25.3 - select query is not taking alias names and exported excel is having sql column headers
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.
Can this Smart Service be used to query an external database in SQLserver?
Instead of using sub-field value, assign the value to the input node directly like this,
Note: Don't include statement ending semi-colon in the sqlQuery
In the "List of SQL Queries and Sheet Names" - I am passing sheetName = "Test1" and in sqlQuery="SELECT * FROM TEST_TABLE;"
But I am still getting error as - "... requires a value. Since this node is unattended, you must enter a value during design".