Skip to main content

CreateExcellFileFromDatabase

Description This activity creates an Excel file using data retrieved from a database and saves it to the specified file path. It is commonly used for reporting and data export scenarios.

Core Functions

  • Retrieves data from the specified database source.
  • Converts the retrieved data into an Excel-compatible structure.
  • Creates a new Excel file based on the database data.
  • Saves the Excel file to the given path.

Inputs

  • ConnectionString:The database connection string used to access the data source.

  • Query:The SQL query used to retrieve data from the database.

  • Path::The file path where the Excel file will be created.

Data Types

  • ConnectionString:String

  • Query:String

  • Path::String

Outputs

  • DataTable:Returns the retrieved database data as a DataTable.
  • Path:: Returns the file path of the created Excel file.

Output Data Types

  • DataTable: DataTable
  • Path:: String

Short Technical Summary

Retrieves data from a database using the provided connection string and query, creates an Excel file from the resulting DataTable, and saves it to the specified path.