Information
  • Author: Xebia
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 24.2
  • First Released:
  • Last Updated:
  • Cost: Free
Share
Home » AppMarket » SQL to Excel

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, After upgrade to Appian 25.3, it is not supporting the table alias in SQL query. Example - SELECT ID AS 'Number', LABEL as 'Prop Name' FROM TEST_TABLE - it gives excel header as ID & LABEL but expectation is - 'Number' and 'Prop Name', since thi sis very useful for exporting more than 170 columns of data in excel.

    Please suggest if anyone knows any work around or suggestion

Comment

  • Hi, After upgrade to Appian 25.3, it is not supporting the table alias in SQL query. Example - SELECT ID AS 'Number', LABEL as 'Prop Name' FROM TEST_TABLE - it gives excel header as ID & LABEL but expectation is - 'Number' and 'Prop Name', since thi sis very useful for exporting more than 170 columns of data in excel.

    Please suggest if anyone knows any work around or suggestion

Children
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.