Read/Write from/to Excel file

datatable
excel
uiautomation

#1

I want to Read a range from excel file and add to a new column the text “Match” to all rows thats match a criteria.

Would like some tips and trix on how to do this?


#2

First Take all data into a DataTable…
Then Use Add Data Column Activity to add a column first
Then Run For each Data Row Loop and If [Coumn]="" matches criteria update that add coumn value for that row…

Finally Take that DataTable and WriteRange to set …

I hope this will help u…:slight_smile:


#3

Thanks, how do i do the update?


#4

Once You got used “Add Data Column” Activity there you need to give name for the column…

SO while looping in foreach data row…

row.item(“CoumnName”)=Value will update the respective added column…:slight_smile:


#5

ScheduleData.xlsx (8.6 KB)
ScheduleTemplate.xlsx (112.4 KB)

How to populate data into a shedule template form and if same dataareaid repeats count+1 how to assign previous value in array