How do i get the column letter based on header text

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

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

1 Like

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