can you show a short recording to understand..as of now what I understand is you need to write data from excel to some app…in excel po might have multiple rows and all row items should go into one page of app..
if this is what is needed instead of for each row in excel ..you need to read the data first into datatable then group by the PO number to get all the po numbers as one item and then loop on each PO or group
dt.AsEnumerable.GroupBy(function(x) x("PO Number").ToString).ToDictionary(function(x) x.Key,function(y) y.CopyToDataTable) rhis will create a dictionary with po number and its related table of info which can be looped
and then writing to app depends on how the UI is may be you can loop through each line in the respective PO tables
cheers