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.