Hello Everyone,
I am trying to filter an excel sheet in c# which works fine. But I want to copy the filtered data into a new worksheet so that the unfiltered data is not included in the new worksheet.
Whenever I use the CopyFrom method or something similiar the autofilters get copied aswell into the new worksheet. Is it possible to copy only the filtered data into the new worksheet without the filters turned on? (see attachments for clarrification. First.png is the first worksheet. Second.png is the filtered data that will be copied from the first worksheet without the filters turned on)
If it is possible to delete the unfiltered data in the first worksheet then that would also be great. I already tried this with for loops but my file is simply too big and therefore it takes too much time. This is the reason why I want to use the autofilters. Any help will be much appreciated