Updating Excel when query re-executed

Help Studio
, ,
1

Hello,

I created a workflow which it will execute a query in MsSQL and the data will be written on excel workbook at my computer. The workbook will be sent to spesific e-mail groups via e-mail.
The process is going to be worked once in a day with trigger.

My question is that how the workbook can be cleared and filled with new data everyday? Because when I tested it was not changed and sent the excel with old data.

Thank you in advance,

Capture
Capture357×710 33.1 KB

2

@cagatay.kater
Excel Application Scope
a. Clear Range - Clear existing data in the workbook (optional)
b. Execute MS SQL Query - Retrieve new data and store it in a DataTable
c. Write Range - Write new data to the Excel workbook

1 Like
3

Thank you ! I’ll try it asap