Convert given excel column name to column Index, ex ‘A=0’, ‘AA=26’
Other day I needed to convert excel spreadsheet column name to column index when having 200+ columns is easier to express as ‘FB’ instead of 157 A = 0 B = 1 AA = 26 AA = 27 FB = 157 This code will work for any number of column names. /** * Convert given …
Convert given excel column name to column Index, ex ‘A=0’, ‘AA=26’ Read More »