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…

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.

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:

Hi @Suchi3190 , Use for each row activity. Inside the for each row use assign activity row("value")=string.empty Or row("value")="" Regards, Arivu

I tried it… its not working :frowning:

Hi @Rajtk7 , Check the following Workflow, you might get an Idea. Find Cell Position.xaml (16.3 KB) Sample_data.xlsx (8.9 KB)

[image] ClaytonM: For Example, rowIndex =(datatableVariable.Rows.IndexOf(datatableVariable.AsEnumerable().Where(Function(row) row(0).ToString.Contains(“word”)).ToArray()(0))+1).ToString Hello , I had a similar kind of problem which was resolved using this. Thanks :slight_smile:

Find a cell position in Data Table

Help

Suchi3190 (Suchita Shaniware) April 16, 2018, 7:14am 12

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

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

Find a cell position in Data Table

Related topics