Hello Fellows,
Here I have a workflow and I want whenever I’ll run the workflow the current date’s day should be there as a new column of the sheet.
How can we do this?
Thanks in advanced
Hello Fellows,
Here I have a workflow and I want whenever I’ll run the workflow the current date’s day should be there as a new column of the sheet.
How can we do this?
Thanks in advanced
Hi @Vrushali_Gave,
Here is a simple example. You need to have defined table inside the excel table to make it work.
Result:
In addition to the way @Pablito said u can try this way too
You can try something like this
Read range to read the excel and store in datatable dt1
Use assign activitiy to assign as below
day_1= Now.ToString(“dd”)
Use invoke code with code type as c# with passing dt1 as in/out argument and day_1 as input argument with below code
dt1.Columns.Add(day_1)
Next use write range to write the updated dt1
Hope it helps you
Regards
Nived N
Happy Automation
@Pablito @NIVED_NAMBIAR Thank you for your response
Workflow: follows some steps
Note: the entire process will execute only once a day
The next day the matching row cell will be the same but the column will be current dates day
Therefore I want to add today’s date column every day and the column will add from “F” name of the column in the excel
@Pablito @NIVED_NAMBIAR I have tried both solutions but not worked for me
Hope you guys got the query
Thanks in advanced
What error u are getting while executing in my answer which I suggested above ?
Can u show how the output sheet is ?
Put the direction of DT as In/Out
I had done the following
Input excel file
Output excel data
It add the new column with column name as current date
Workflow
Main.xaml (7.0 KB)
Hope it helps you
Mark it as solution if it resolves ur query
Regards
Nived N
Happy Automation
@NIVED_NAMBIAR It’s replacing today’s date with yesterday’s date. But I want to add today’s date next to yesterday’s date column
How can we do this?
I got the it correctly by executing same workflow which i had sent you
Regards
Nived N
Happy Automation
Can u show the workflow u had use