Read and Write in same excel sheet


#1

Hello,

I have a excel sheet with 5 columns and 3 column data already filled and need to write the remaining 2 column data after checking a condition in the application. Could you please give an idea?

Thanks


#2

Hi, @Ula

You can try this one.

Use excel application scope and read range to get your table values. Create for each row activity and add get row item (for the checking you want to do).

excel

Then just add the validation part and write to excel.
excel2

Regards,
Mharlieee


#3

1)First you can use read range and convert it to datatable
2) manipulate it with your logics in for each .
3) use append range in for each when you manipulate it and after your conditions satisfies

Thanks
Karthick


#4

Thank you @Mharlieee . It helped me a lot.


#5

Thank you @karthick