SQL to Excel

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!

HI team, I am facing one issue while generating excel using this plug-in as follow:

"The following error was raised by the Export to Excel function: Invalid char (/) found at index (8) in sheet name 'Report-1/16/2024'" 

Unable to debug the error as the given template is plain and simple and there is no char (/) as such

Hi Team, Any update on this ?  Can we please try to increase the timeout since all our queries and exports are failing which is causing issue on PROD. 

#### CLASS: ExportSQLToExcelNew.java ##### Path: sql-to-excel-1.4.0\com\appcino\as\sqltoexcel\ Line 172:    stmt.setQueryTimeout(60); ################################### I was able to verify this by creating a simple SQL statement. SELECT SLEEP(70);  ---> This SQL statement will trigger the "max_statement_time" timeout error   whereas: SELECT SLEEP(50);   -----> will not trigger the error since the statement executes before 60 seconds. That being said, I was able to overrun this by using the following query: ="SET STATEMENT max_statement_time=90 FOR SELECT SLEEP(70);"   ---> This will increase the plugin's default timeout.  

Hi Team, is there any configurable timeout setting. we are getting error saying "The following error was raised by the Export to Excel function:  (conn=2467368) Query execution was interrupted (max_statement_time exceeded)". Can i set it up to 70 or 90 sec for the query to run. Please help.

Hi,  Executing query similar to this one returns MariaDB syntax error: SET @pivot_sql = 'SELECT * FROM paqsurveyrawreport'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;      Any workaround ?

An error occurred while executing a save: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

We also tried the fix with applying Trim on sql.

Getting the following exception when trying to export 200 columns to an excel:

Exception in thread "ThreadPoolTaskExecutor-329094" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V