I have excel which has data of 15000+ rows and 40+ columns. After running the automation, I need to update the status against each row (in specific cell) by applying the filter in excel. Example, I will use emp code as filter and update the status against it in specific cell.
I felt, using datatable and writing in excel for every iteration is not a good way of dealing it.
Is there any way to write value directly into specific cell without using DT? Please suggest.