Read and Write in same excel sheet

[Boopathi (Boopathi Manogar)]

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

[Mharlieee]

Hi, @Boopathi

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).

Then just add the validation part and write to excel.

Regards,
Mharlieee

[karthick]

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

[Boopathi (Boopathi Manogar)]

Thank you @Mharlieee . It helped me a lot.

[Boopathi (Boopathi Manogar)]

Thank you @karthick