How to get cell number in excel?

Hi all

How to get cell number in excel ?

For example, I search by the contents of the text and find the cell. And I need to write down the number of this cell

Screenshot_2

Thanks

GetCellNo.xaml (5.4 KB) test.xlsx (10.2 KB)

Sample attached…!

You have to give your excel file path, sheet name, search value. Then test it.

Thanks!

1 Like

In this case create an array of string variable Columns = ("A","B","C",..., "AZ") .

When using Write Cell you will set the cell to
Columns(columnIndex)+rowIndex.ToString

`Columns(0)` will return "A"
`Columns(1)` will return "B"
and so on

Everything is parametric now.

//OR//

Refer:CELL_No.xaml (5.5 KB)Name.xlsx (10.2 KB)

1 Like