Convert SQL Query to Excel File
  • 12 Mar 2021
  • 1 Minute to read
  • Dark
    Light

Convert SQL Query to Excel File

  • Dark
    Light

Article Summary

Example Lab Article
While Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.


Overview

Example Lab Details

Version6.12.1
Root FolderExample Lab - SQL Query to Excel File
Modules None
DependenciesNone

This Example Lab demonstrates how to execute a SQL Query Integration and convert the results into an Excel File to download.


Explanation

This Example Lab has the main Flow that will execute a custom SQL Query Integration in order to return the data as a Data Structure (located in System - Designers - Data Structures - Query Definition Types). On the Query step in the Flow, we can return the values as a CSV file. After that, the Flow will pass the Output into the "Convert CSV Results from Query to Excel" step. This will then convert the CSV File into an Excel File, which will then be passed as Input into the "Download Excel File" Form. Once this Form opens, the user can then download the Excel File.

Reference Articles



Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.12.1 or later using our Importing/Exporting article.





Was this article helpful?