Excel -filter condition s

Help
1

Hi ,

1)i want to open below excel sheet and need to check filter is applied in thee sheet1 .
2)Then i need to remove the filter .
3)Please explain me with example xaml filessample.xlsx (7.9 KB)

1 Like
2

@vikumars1
Buddy in once you open excel application scope activity with the path of the file mentioned and while trying to read the excel with read range activity , we got an option in the property to take whether the filter into consideration or not…if its enabled while reading excel, that filter will be taken into consideration or if its disabled it wont take the filter into consideration buddy…with that we can use a excel with or without filter to get the data from it buddy like this

image
image997Ă—421 41.5 KB

Cheers

1 Like
3

Hi @vikumars1
Here is your xaml buddy
its resolved

Cheers…

removefilter.zip (11.5 KB)

4

is that working buddy… @vikumars1

Cheers

5

Hi Palani ,

I have one more doubt .
Am reading entire data from the sheet1 .

Now

  1. i need to create new sheet.
    2)then paste entire data into the newly created sheet .
1 Like
6

buddy @vikumars1

  1. use read range activity with add headers enabled in the property
  2. then use a write range activity with new excel application scope and the pass the output datatable obtained from read range to the write range…kindly enable add headers in the write range as well, this would paste the entire data into the newly created sheet

Cheers buddy

Keep going

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.