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
  • 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

    9. Added New lib that is compatible with the new version.
    10. commons-collections
    11. commons-compress
    12. poi-ooxml-lite
    13. Remove the deprecated setter function that sets cell style

Comment
  • 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

    9. Added New lib that is compatible with the new version.
    10. commons-collections
    11. commons-compress
    12. poi-ooxml-lite
    13. Remove the deprecated setter function that sets cell style

Children
No Data