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


#1

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


Filter table on integers
#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


#3

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


#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)


#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