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
  • Also, this is not from a single table but need to join multiple tables and we had used previously a view but it gets slow while generating this excel report out.

  • 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

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

  • Did you find any resolution for this as we are also facing some issue with excel size limitation. It seems to be not generated for >36 MB

  • will this plugin able to extract 40+ MB data from table?

  • v2.0.0 Release Notes
    • Vulnerability Fixes
  • Plugins listed on the AppMarket undergo periodic review. Upon completion of a recent review, this listing has been archived. If you have any  questions, please contact us via  appmarket@appian.com.

  • Hi Team,

    [Deprecated] Export SQL to Excel smart service is failing in our DEV environment Appian version 23.2. Geeting below mentioned error:
    "The following error was raised by the Export to Excel function:  null"

    Same smart service is working in another DEV environment of same version.

    Please do the needful on this issue.

    Regards,
    Sandeep

  • Hi team,

    The client has asked us for a detailed report on the limitations associated with this plugin.
    We need to know the maximum size of the Excel file that the plugin can generate.

    We also need to know if there are any limitations on the amount of data that can be retrieved from a database query.
    It is important to clarify whether these limitations are related only to the total size of data that can be retrieved, or if they are also related to the time required to execute the query.

    Thank you in advance for any information you can provide.

  • Hi Team, We are facing an issue with the Font size in Excel export . The base template was set to font size  9 for result set (all the cells except header) and Calibri Light as font style.

     When we are exporting via this plugin we found that some of the cells have the font size as 9 and some of them have 11 (which is not expected). 

    We have recreated the template and uploaded multiple times but no luck. 

    We reached out to Appian support - but they redirected to check here.

    Any help much appreciated!