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

  • Is there a reason that the exported DATE_FORMAT is set to dd-MMM-yyyy and the cellStyleDate (line 166) is set to "m/d/yyyy"? When my spreadsheets are generated date columns are left aligned (meaning excel thinks its text) and I suspect the reason for that is the mismatch in these formats. Was this a purposeful choice? Have you seen this issue with the excel spreadsheet and dates?

Comment

  • Is there a reason that the exported DATE_FORMAT is set to dd-MMM-yyyy and the cellStyleDate (line 166) is set to "m/d/yyyy"? When my spreadsheets are generated date columns are left aligned (meaning excel thinks its text) and I suspect the reason for that is the mismatch in these formats. Was this a purposeful choice? Have you seen this issue with the excel spreadsheet and dates?

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