I am working on this process where there are 5000+ row item with unique key.This data is stored in an excel which act as log book for the process. The input comes from user via mail and the value is updated according to unique id.
So what I did is used read range activity and got all the data from log book as well as from the input(from mail) from the user.
Log book Datatable: DTLog
User input datatable: DTUser
used nested for each in both datatable and “if” to check unique id and updated the value in the respective row of DTLog datatable.
After the execution of the for loops, I write the datatable to the Log book and thus the values are updated.
The issue sometimes comes up is the log book(excel) is filtered and because of that a lot of garbage value is created. Its like updating the DTLog to filtered excel log book.
Can you help me with how can I check if the excel is filtered or what can I do to remove the garbage value while writing the data back to datatable.
p.s.: I know using nested for loops is bad but what done is done and changing it will be another big headache as there are more things under consideration in the process.