I am trying to read row by row in a DT (excel data converted) and then check if the value of the cell contains something specific (circa 120 different scenarios). The read cell value can fall between 8 highlevel categories (corresponding to 8 different columns in final excel file) and underneath these different categories different scenarios can also exists (combined probably like 120 scenarios).
Hence, I’ve made a For Each on the DT, assigned a counter, read cell and then the various if statements.
After the For Each I then have a excel application scope where the assigned values from the if statements then are written to the cell in the final excel sheet. All seems ok, however there is something that does not seem completely working.
(1) Sometimes a row might contain information that needs to be assigned to several variables, however it seems like that as soon as one if statements becomes true then it ends the either for each - is that true? If yes, how to ensure that a For Each is not complete before the specific cell is checked for all combos?