Hei! I would like to ask you if it is possible to find an exact position of a cell in Excel. I have all data from Excel file in a proper variable and I am able to find if this file contains specific word/number/value. However, I need to know where in my excel file this word/number/value is (for exa…

Hi Tomas, Yes you can do this. You will need the row number within the DataTable and the column Index. To get the row number, you can simply have a counter inside a loop (but that can be slow). If you are using vb.net to pull out the row that contains a word then you can use the .IndexOf() functi…

Hi ClaytonM, I have the same question to ask. How to find a cell position in DataTable. I am beginning in Uipath. So after review your help, I don’t know how to do like you. I tried to test before. But don’t have result. I use loop each row and when the value of cell is “S.TL”, it will show me…

Hi Clayton, Do u have xaml files related getsheets count

I have one query :slight_smile: How to clear the contetnt of whole column of datatable.

Hi @Suchi3190 , use for each row activity. inside you can use for each activity to loop through the column values. item(ColumnIndex)=String.empty Regards, Arivu

Hi @arivu96 Its not working :frowning:

HI @Suchi3190 , Refer this xaml file. DataTableColumnValuesToEmpty.xaml (10.8 KB) Regards, Arivu

Hello, Its not working :frowning:

I am using the file as dictionary and that file column i want to clear. is it problem?

Find a cell position in Data Table

Help

Suchi3190 (Suchita Shaniware) April 11, 2018, 9:34am 7

That will remove the column , i dont want to remove the column i just want to clear the values of that column for each row.

1 Like

Index of cell

Topic		Replies	Views
Get row and column index of cell with specific value Help datatable , activities	4	10405	April 28, 2019
How to find the particular cell value position in datatable Help studio	4	7486	January 6, 2019
Is there any way to get the position of a cell from a DataRow? Studio datatable , excel , activities	5	1741	November 22, 2021
Find position of a cell Help datatable , excel , activities , string , question	10	5203	November 22, 2021
Find cell with String Value and get no. of row, name of column Help excel , activities	17	21765	November 26, 2019

Find a cell position in Data Table

Related topics