Filter date and enter data in a different column

Help Studio
, ,
1

Hello!
I am a begginer in ui path. I have done till the part where I need to filter the date, After filtering the date, I want to input data to column AE (the same row as the date)
unsure how that can be done. Any help will be appreciated, please explain in detail as well if possible.
Thank you
/Akshana
image

2

Hi @lalitrocks.akshana

Your query is quite confusing could you be more specific. If possible then share the required output file image also.

3

image
I want the data to be pasted on the highlighted cell.
(the data that needs to be pasted is in the form of a variable)
I just want to know how to be able to paste on that cell (Column AE) after the date is filtrerad as this is done on a daily basis.

4

Hi @lalitrocks.akshana ,

→ Indicate the Excel file you want to write to using the “Excel Application Scope” activity. Path to your Excel file and create the output in workbook in the properties panel.
→ Drag and drop a “Write Cell” activity onto your workflow.

image

Hope this will helps you.

Thank you

5

this is a dynamic data and the filtered date changes every day (therefore the row the data has to be written in, in column AE)
Using write cell I can designate it to a particular cell but then the process will rewite in that same cell everythime.

6

Okay @lalitrocks.akshana ,

So you can apply
→ “Read range workbook activity” and the output is stored in the datatable.
->Apply for each row in datatable activity provide the datatable(Name of the datatable) and item(Row)
->Assign a string variable(str_Row) and it’s value is Row(“Date”).tostring.
->Now you can apply “Excel Application Scope” activity. Path to your Excel file and create the output in workbook in the properties panel.
→ Drag and drop a “Write Cell” activity onto your workflow. In the properties panel provide the value as str_Row.