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 @Automater999
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.