Getting only especified lines on Excel

Help
,
1

Hi Guys,

I am having a problem to think how to filter lines on Excel. I need to get a sheet, and filter the lines only if the line has “False” set.

image
image964×125 6.36 KB

If the line is set to “False”, i will get the intire line information, and start the process, can you guys please help me out ?

2

Hello @Lucas_Silva

You can get it done using the below steps.

  1. Use read range to read the data onto a datatable
  2. Use filter data table activity to filter out and get only the values with false in that column. In this activity specify the column name which you want to filter and the value you want to keep the records of.

It will work for you :slightly_smiling_face:

2 Likes
3

hi
hope these steps would help you resolve this
–use excel application scope and pass the file path of excel as input
–inside the scope use a read range activity and get the output with a variable of type datatable named dt
–now use a simple assign activity like this
dt = dt.Select("[Request Status] = ‘FALSE’ ").CopyToDatatable()

now this expression will give ONLY the rows having the Request Status column with value as FALSE

so we can now use the dt datatable in a FOR EACH ROW activity and make use of the values from each column we want like this
row(“yourcolumnnname”).ToString

Kindly try this and let know for any queries or clarification
Cheers @Lucas_Silva