SQL to Excel

Overview

Generating Dynamic Budget Reports using multiple database tables using SQL to Excel Smart Service.
Import Financial Budget of the Organization right from the Excel Sheet in a Single Step.
Use Predefined Excel templates to apply styling on the generated sheet.

Key Features & Functionality

Ability to Export SQL Data in a predefined template for dynamic reports
Import Excel Data in CDT
Excel Change Sheet Order
Delete Excel Sheet
Multiple templates can be associated with multiple worksheets of a single workbook.

Appian AppMarket 3 days ago
v2.0.1 Release Notes
- Vulnerability Fixes (updated all jar files to the latest version) and latest Appian version fixes (Changed getColumnName() to getColumnLabel() method in all instances. )
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
kiranjorwekar 21 days ago in reply to kiranjorwekar

Also, this is not from a single table but need to join multiple tables and we had used previously a view but it gets slow while generating this excel report out.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
kiranjorwekar 21 days ago

Hi, After upgrade to Appian 25.3, it is not supporting the table alias in SQL query. Example - SELECT ID AS 'Number', LABEL as 'Prop Name' FROM TEST_TABLE - it gives excel header as ID & LABEL but expectation is - 'Number' and 'Prop Name', since thi sis very useful for exporting more than 170 columns of data in excel.

Please suggest if anyone knows any work around or suggestion
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
sreenevasans126 2 months ago

when trying to use this function on Appian 25.2 on prem env with updated plugin version 2.0.0 ,

we are getting error "sheet index(4) is out of range (0..3)" . Which was working in the Appian 22.3 environment with its respective 1.3.0 version.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
piyusha6151 8 months ago in reply to josedelgadop

Did you find any resolution for this as we are also facing some issue with excel size limitation. It seems to be not generated for >36 MB
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
piyusha6151 8 months ago

will this plugin able to extract 40+ MB data from table?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago
v2.0.0 Release Notes
- Vulnerability Fixes
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago

Plugins listed on the AppMarket undergo periodic review. Upon completion of a recent review, this listing has been archived. If you have any questions, please contact us via appmarket@appian.com.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Sandeep over 1 year ago

Hi Team,

[Deprecated] Export SQL to Excel smart service is failing in our DEV environment Appian version 23.2. Geeting below mentioned error:
"The following error was raised by the Export to Excel function: null"

Same smart service is working in another DEV environment of same version.

Please do the needful on this issue.

Regards,
Sandeep
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
josedelgadop over 1 year ago

Hi team,

The client has asked us for a detailed report on the limitations associated with this plugin.
We need to know the maximum size of the Excel file that the plugin can generate.

We also need to know if there are any limitations on the amount of data that can be retrieved from a database query.
It is important to clarify whether these limitations are related only to the total size of data that can be retrieved, or if they are also related to the time required to execute the query.

Thank you in advance for any information you can provide.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel