Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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:
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.
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