Data Table FilterDataTable

Help
1

Inside FilterDataTable

in filter wizard apart from mentioning
can we also use :

2

@ABsingh,

Can you please tell me more details and what you want to do this ?

3

rather than use one table as input and specify another excel file as output or same file can’t I take input from say file1.xls worksheet 1 and post output to file1.xls worksheet 2

4

@ABsingh,

Yes, you can do this also.

1 Like
5

Cheers Mate. Thanks for the assist!

6

@ABsingh,

Declare one new DataTable and store filterDataTable result into it. Then use write Range to write into file1.xls worksheet 2.

7

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