Please look at scenario below.
The tabular data is from Excel, which I need to extract and input the web form. Basically, the tricky part is after column E, where the number of columns are not fixed.
As you can see from OrgID 001, when column E (Siblings = Yes), we can maintain additional siblings details. In this case, there’s 2 siblings. So have to extract this info and input to web form.
But for OrgID 002, when it has only 1 additional sibling. Thus, just need to input the first sibling details.
I only know how to extract fixed column data via row.Item(“Column Name”).ToString. Please advise how can I achieve the requirements above. Thank you.