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): 20.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 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.

Comment

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

Children
No Data

© 2024 Appian. All rights reserved.