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	2831	March 1, 2020
Convert Excel column letter to index Studio excel , activities , question	6	5373	March 17, 2020
Convert excel alphabetical characters into column numbers Help	3	2050	July 29, 2020
Convert column index to Excel column letter Studio	4	4693	October 20, 2021
Convert Column index to column letter Activities datatable , excel , activities , question	14	9031	May 20, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Getting column index from Excel

Related Topics