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!

2 Likes

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)

2 Likes

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

Hi Sahil Can you help me on below please?

Sample.xlsx (32.8 KB)
File is attached and steps to perform is also in the File.

Let me know if you need more details.

Thanks