I am trying to read from Excel file starting from column "AX" up to column "CU". This is on the header only.
My logic is not working right.
Dim j As Integer = 0
For j = 1 To 50
Dim firstalpha As Integer = j / 26
Dim secondalpha As Integer = (j - 1) Mod 26
Dim letter As String = Convert.ToChar(65 + secondalpha)
If firstalpha > 0 Then
letter = Convert.ToChar(64 + firstalpha) + letter