Excel Manipulation of row and column

Help Studio
, ,
#1

I have an excel sheet, from where i have to read column D and find which row contains a particular keyword,“Shilpa” and find the value of column C of that particular row .

Can any one suggest an idea

#2

@Shilapshree_Mohanty

give a try to setup the flow as following:

  • Excel ApplicationScope
    • read range acitvity
  • filter datatable acitvity - filter on D contains Shilpa
    get value from the filter result
  • as an alternate to Filter Datatatable - use a Lookup datatable activity
1 Like
#3

Hi @Shilapshree_Mohanty

check as below

hope this helps you

Thanks

#4

Sorry its a csv file
Can you let me know the approach

#5

@Shilapshree_Mohanty

Use Read CSV activity->Output to a datatable

Remaining process is same

Hope this helps you

Thanks

#6

i tried and got the values of filter data table but how do i store all values in a array or string and use it one-by-one?

#7

The output of filter datatable activity is datatable

It contains the row which had keyword “Shilpa”

If it contains one row then use the followingto retrive the Column C value

datatable_variable.Rows(0)(2).ToString

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

#8

I tried to use filter data table and got the output of required numbers , now, how can i store them into a variable and fetch values 1 by 1?

#9

@Shilapshree_Mohanty Can you please explain your requirement in a bit more detail, You can provide us with the below details, so that we could suggest a better approach or a solution.

  1. Sample Input Data
  2. Operation to be performed
  3. Expected Output