I read a excel sheet with hundred rows and 20 columns without headers. (so the column name was column1, column2 …) The data of this datatable contains a unique word called “Test”. How can i find out this “Test” was from which column ?

@Wei_Ji_Kwok use this sequence uipathF.xaml (13.1 KB) example input [image] result [image]

Looking for a specific words in a datatable

sangeethaneelavannan1 (Sangeetha Neelavannan) December 5, 2022, 2:12am 3

Topic		Replies	Views
How to check for every cell if it contains a particular string in a datatable Help excel , activities	3	1726	September 4, 2020
How to find the particular cell value position in datatable Help studio	4	7421	January 6, 2019
Work on Excel Sheet Studio datatable , excel , studio	18	1756	July 22, 2020
How to Find a string in Datatable Help	5	9201	December 6, 2018
How to get Column Range from Excel Help datatable , excel , uiautomation , activities , studio	3	6598	August 27, 2018