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

Hi, I want to write in a cell givin the column’s name because it’s possible the number of columns can change

image

1 Like

Hey @Christian_Maury

What about the rows, you will be having a single row or multiple one’s.

Thanks :slight_smile:

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
Third step: Concatenate with the row number to get the cell

1 Like

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