I am working on dynamic Excel Automation.
where I need to pic data from cell and store it in a variable.
like in the image I have to pic today data i.e. 123 and store in a variable and tomorrow data i.e. 421 and store in a variable.
Hi ,
If i understand correctly you trying to get the excel values you can use the “Read range” activity and pass the output datatable into “for each row” activity to compare and that the values into the data table and pass them to the excel.
I have to only read today data i.e. 123 in a variable and tomorrow data i.e.421 in a variable and it can be anywhere in the excel so first I have to find in today and go one cell right copy data and then find tomorrow and go one cell right and copy data.
Take an assign activity and using string manipulation , get the value “E4” - Assuming 123 is always in the right side … so if today cell number is A123 , This assign will give you B123.
Take a Read cell and pass E4 - This will give you 123.
Second way :
Use an AnchorBase activity with anchor to “today” and Read Cell in the action.