Filter data and write them in a new excel workbook

excel
howto
studio

#1

Hi!

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!

Thanks


#2

@jbharathkumar

Hi!!

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


#3

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


#4

Main.xaml (9.7 KB)

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

Thanks
Vishnu