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

Help Studio
, ,
1

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

image

2 Likes
2

Hey @Christian_Maury

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

Thanks :slight_smile:

3

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:

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

1 Like
4

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