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

  • Hi Team,

    I am using this smart service to export sql result to excel. But its not exporting more than 6700 rows of data. Getting below error

    The following error was raised by the Export to Excel function:  Specified named range 'Fun' does not exist in the current workbook.

    Any help would be appreciated.

  • Hi Team,

    When using the SQL to Excel Smart Service and exporting data, all the date time fields are converted to date fields.

    We need to use DATE_FORMAT function in sql to keep date time as is. This is not the case with earlier Export SQL to Excel Smart Service in Excel Tools.

  • Hi Team,

    I have used SQL to Excel Smart Service and am facing an issue with the same. 

    One of my database fields has "=> First point, => Second point" as value and when I try to export, I am facing the below error,

    "Parse error near char 0 '>' in specified formula '> First point, => Second point'. Expected cell ref or constant literal"

    Could you fix the error in the plugin!!?

    Thanks in Advance!!!

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