SQL to Excel

Overview

  1. Generating Dynamic Budget Reports using multiple database tables using SQL to Excel Smart Service.
  2. Import Financial Budget of the Organization right from the Excel Sheet in a Single Step.
  3. 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.
Anonymous
Parents
  • 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?
  • 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"

Comment Children
No Data