Update Excel With DataTable Variables Each Day?

Help Studio
1

Hi all,

I have an excel sheet with columns like below:
image
I have two sql queries that return data, and I need to paste that data into the correct cells according to the date. So if I run the query today, I want it to paste the data into the row for 4/13/2020.

Query 1: results should go in column B & C respectively
Returns: 800, 900

Query 2: results should go in column D & E respectively
Returns: 500, 650

So for today I would want my updated excel to show:
image

After I output the sql queries to datatables variables, I am lost on what to do…any help would be appreciated!

2

hi anyone can help on this as i have similar question for this