How do i get the column letter based on header text


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


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

1 Like

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