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

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

Children
No Data