How can I write in a Excel cell givin the name column?

[gustavo.cervelin (Gustavo Cervelin Custódio)]

Hi @Christian_Maury,

Considering these conditions, you could get the column index based on its name, and convert it to column letter.

So…

First step: yourDataTable.Columns.IndexOf("columnName")
Second step:

Convert integer to Excel column

Hello, I have managed to get the column number e.g. 4 and I want to change this into “D” so that I can use this to write stuff in to Excel. Any help?

Third step: Concatenate with the row number to get the cell