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
Thanks
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
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!
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)
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