I have an excel sheet I use read range and create a DataTable.
I want to iterate through each column (number is unknown) and the column has no header. The column I want to start gathering data from is G. The row I want to gather data from is 14, ie G14.
If column G is null then the rest of the columns will be, too, so no more checks are needed.
Otherwise, if it is NOT null, I want to read column G, row 14 and then check the next column, example H, row 14. Once the values are null again, I want it to stop.
I have tried For Each Row: For Each row in DataTable
Then I don’t know how to specify the row and columns so it always looks on row 14 and starts at column G and iterates through the unknown number of columns.