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

Works perfect! thanks for show this activity :wink:

Hi @Aibek_Abubakirov,

To search the content in excel you can use the activity called “Find”. It will return the cellinfo and row index.

Video demonstration

Regards
Balamurugan.S