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:38am 2

@Suzana_Joby Please follow How to get column index? - #7 by Vijay_Tulsalkar

1 Like

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

Most Active Users - Yesterday
mkankatala
Anil_G
pravallikapaluri
Yomi_Oluwadara
Yoichi
postwick
Parvathy
vrdabberu
DimitriLYR
lrtetala
More details...

Getting column index from Excel

Related Topics