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.

alejandroa0649 10 months ago in reply to aleksandrss0001

Hello, we had this problem. We were using the fields "cell keys" and "cells values" and the problem was that some values had unnecessary spaces. We fixed it with a trim in the previous rule that calculates the values.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
neelimaj2706 11 months ago in reply to davidbueno

Try using trim function in your SQL query on text columns which has space in the start of the value. for e.g. your sql query should be something like "SELECT TRIM(ADDRESS) AS Address from ADDRESS_TABLE"
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
davidbueno 11 months ago in reply to aleksandrss0001

Me too
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
natalias7974 over 1 year ago in reply to aleksandrss0001

I am facing the same issue. Is there any update on when it is expected to be solved?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
neelamj33 over 1 year ago in reply to aleksandrss0001

I am facing same issue.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

aleksandrss0001 over 1 year ago

Hi, in the last few weeks we are facing an issue with the plugin failing due to the following error:

javax.resource.spi.work.WorkCompletedException: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

Does it seem familiar to you?

Appian AppMarket over 1 year ago
1.4.0 Release Notes
- Fixed Review Comments
- Added try-with-resources for connections.
- Closed some connections in final blocks.
- Fixed the reported vulnerabilities in the plugin as per the vulnerability report:
1. Update the following Libraries to the latest versions
2. commons-beanutils
3. commons-io
4. commons-lang
5. commons-math
6. poi
7. poi-ooxml
8. xml-beans
10. Added New lib that is compatible with the new version.
11. commons-collections
12. commons-compress
13. poi-ooxml-lite
14. Remove the deprecated setter function that sets cell style
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
simples0828 over 1 year ago in reply to Shakilah

I am facing similar issue. please advise how you resolved it.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Shakilah over 1 year ago

Hi, I am not able to deploy this plug in in new environment as part of deployment as it is not listing when searched. Is it because of "This listing is archived."
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
matt.schuchman over 2 years ago

Is there a reason that the exported DATE_FORMAT is set to dd-MMM-yyyy and the cellStyleDate (line 166) is set to "m/d/yyyy"? When my spreadsheets are generated date columns are left aligned (meaning excel thinks its text) and I suspect the reason for that is the mismatch in these formats. Was this a purposeful choice? Have you seen this issue with the excel spreadsheet and dates?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel