I am using a Filter table activity and as it has no output parameter, I am selecting data from excel sheet using CTRL+A & CTRL+C to copy the content. The output from clipboard is in string format and I need it in datatable format for further processing.
Filter table Activity directly affects that excel so filtered results will be shown in excel sheet.
So you can Read that data by using Read Range with “use filter” property checked and you will get datatable.
For Reference: Filter_Results_Datatable_Using_Filter_Table.zip (9.8 KB)
it will generate a new sheet “filter_results” and will write those filter results in that sheet.
How to get the filtered excel output in a datatable?