How do i get the column letter based on header text

Help Studio
, , ,
#1

Hi,

I have a spreadsheet and want to use write cell to write into certain columns based on their header text. The below will give me the index but i would like to get the
actual column. ie. Column D if the header is GFFS

ExtractDataTable.Columns.IndexOf(“GFFS”).ToString

#2

Hi @fflattery
use this way
Convert.ToChar(ExtractDataTable.Columns.IndexOf(“GFFS”)+65).ToString to get column letter name
Regards,
Nived N

1 Like
#3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.