Hello guys…Help pls, I need take only one value in my excel(merge), soo When I find a value in column M I need take this value and use in my process, when the process finish the I need back and continue read my excel to go to next item.
Example: I need Read (349.91) and do process, after finish I need take (339.67)…and etc.
Read excel sheet to datatable
Apply filter and remove the empty rows in column M and place only Coulmn M as Output column.
Now you have only one column M with Data in OutputDt, then iterate through it and do operations if needed