Use data from MySQL to generate an Excel spreadsheet and send it to an e-mail address.
Run the specified SQL Query against a MySQL database to obtain the information needed to create a spreadsheet, then send it to the specified recipients via e-mail.
Variables
MySQL Database with the data needed to create the Excel Spreadsheet.
SQL Query to use to create the content in the Excel Spreadsheet.
Date and time where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.
SQL query to use to determine the end point of the data to process.
Parameters to use in your SQL query, if any. Refer to slide out help for more information.
Name of the Excel Spreadsheet file to create.
Optional name of the first sheet to create in the Excel Spreadsheet.
String to use to represent Not a Number values. Leave blank to use NaN.
String to represent infinity. Leave blank to use inf.
Format string for floating point numbers. For example, '%.2f' will format 0.1234 to 0.12.
Optional list of column names, separated by comma, with no spaces, to include only a subset of columns from the query result in the spreadsheet. Leave blank to include all columns.
Specify the word 'True' to create a header row in the spreadsheet with the names of the columns from the query result. Or specify a list of column names, separated by comma, with no spaces, to create a header row in the spreadsheet with the names specified instead of the columns from the query result.
Enable to include an index column and value for each row.
If Row Index is enabled, specify the name of the Index column.
Row where the query result data will start in the spreadsheet.
Column where the query result data will start in the spreadsheet.
Specify two values separated by comma with no spaces, the bottommost row and rightmost column, to freeze them.
SMTP Server to use.
If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.
Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.
Subject content of the email.
Body content of the email.