How to filter the excel sheet without using filter table activity and excel sheet has to be updated

Help
1

How to filter the excel sheet without using filter table activity and excel sheet has to be updated

2

Hi Shruti,

You could use Datatable.Select method to filter the data table. The result will be an array of Data Rows. You can convert them to a data table and use a Write Range activity to update the data back to the excel sheet.

Regards
Tejus V

2 Likes
3

Datatable.Select method https://msdn.microsoft.com/en-us/library/det4aw50(v=vs.110).aspx

2 Likes
4

Thank You

5

While true, please note that if you’ll be writing back to the same sheet, there will be leftovers.
Initial = 100 rows
After filter = 90 rows
10 last rows will still be there in the excel after writing (duplicates).

6

please can you share xaml

7

attached is the sample

dtArray.xaml (7.6 KB)
table2.xlsx (8.8 KB)

1 Like
8

What if the column name have space between them… Example
Col name : marks out of 625

9

if column names contain space then you have to pass them with brackets().
For your reference - Datatable.Select(“[marks out of 625] >=550”)

Regards…!!
Aksh

10

@vvaidya

I tried solution that you have been provided it is working so fine for column header which do not contain space.

please help

11

@aksh1yadav

This page is denied to download the example

12

That is not an example that is a link and it is working for me.

Regards…!!
Aksh

1 Like