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

balupad14 (Balamurugan (BalaReva)) June 19, 2020, 8:41am 5

Hi @Suzana_Joby

Here is an activity called "Get column index " by column. It may help you.

Thank you
Balamurugan.S

1 Like

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

Getting column index from Excel

Related topics