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: 30 Apr 2020
Last Updated: 25 Sep 2024
Cost: Free

SQL to Excel

Overview

Generating Dynamic Budget Reports using multiple database tables using SQL to Excel Smart Service.
Import Financial Budget of the Organization right from the Excel Sheet in a Single Step.
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.

Parents

Vladimir Vasilev over 1 year ago

Hi, Executing query similar to this one returns MariaDB syntax error: SET @pivot_sql = 'SELECT * FROM paqsurveyrawreport'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; Any workaround ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

Vladimir Vasilev over 1 year ago

Hi, Executing query similar to this one returns MariaDB syntax error: SET @pivot_sql = 'SELECT * FROM paqsurveyrawreport'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; Any workaround ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data