Hey guys! Me again :sob: I want to get the column index/letter for column named “Group” from an excel file. The column can move a lot, but all I want is the column index/letter (e.g. A, J AB, C, D) that corresponds to it Can anyone help?

@Suzana_Joby Please follow Convert.ToChar(yourdatatablename.Columns.Indexof(columnindex)+65).ToString [image] Column index in alphabets Help yah sure we can get the column index with this expression Convert.ToChar(yourdatatablename.Columns.Indexof(columnindex)+65).ToStr…

Getting column index from Excel

Help

Arpit_Kesharwani (Arpit Kesharwani) June 19, 2020, 8:43am 6

@Suzana_Joby Please follow
Convert.ToChar(yourdatatablename.Columns.Indexof(columnindex)+65).ToString

3 Likes

Topic		Replies	Views
Column index in alphabets Help	13	3252	March 1, 2020
Convert Excel column letter to index Studio excel , activities , question	6	6342	March 17, 2020
Convert excel alphabetical characters into column numbers Help	3	2234	July 29, 2020
Convert Column index to column letter Activities datatable , excel , activities , question	14	10251	May 20, 2022
Convert column index to Excel column letter Studio	4	6389	October 20, 2021

Most Active Users - Yesterday
Llessur
AJ_Ask
manasrlenka25
Sanjay_Bhat
More details...

Getting column index from Excel

Related topics