Overview
Key Features & Functionality
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.
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
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.
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
will this plugin able to extract 40+ MB data from table?
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.
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
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.
Hi Team, We are facing an issue with the Font size in Excel export . The base template was set to font size 9 for result set (all the cells except header) and Calibri Light as font style.
When we are exporting via this plugin we found that some of the cells have the font size as 9 and some of them have 11 (which is not expected).
We have recreated the template and uploaded multiple times but no luck.
We reached out to Appian support - but they redirected to check here.
Any help much appreciated!