Get last column with row value

Help Studio
2

Last column can be found with the following formula: YourDataTable.Columns.Count (NOTE: I am not counting column index, because for this next portion to work you want column 1 = column A)

Use the information found in this post to convert that from a number into a letter: Get last column of Excel sheet in Alphanumeric form - #7 by aksh1yadav

To get the first row with data the easiest way is likely to use a for each loop to check if row.item(YourColumnIndex).ToString = string.empty. Then add 1 to that row index (since datatable index starts at 0, but excel index starts at 1) and the output in the end should be G5