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

Getting column index from Excel

Related topics