Filter data and write them in a new excel workbook


My task is simple. I have to apply multiple filters to the data and then write the filtered data into a new excel sheet. I was able to apply multiple filters on the data but was not able to write or append the fitlered data to the existing data in an excel sheet.
I have used the write range but it was throwing me an error. Any help on this would be appreciated!




what error you have… do you have any screen shots and can you send your flow and sample excel sheet

First you must print the DataTable after apply multiple Filter…
Check whether your Filter operation is working or not…
And then try to Append your data to new Excel…
It will show easily, where the error will occur

Main.xaml (9.7 KB)

You can use this sample and you can get an idea to improvise for your purpose