I want to apply a filter to an excel sheet, copy the resulting rows to another sheet, and save it using C# (interop).
I tried this:
range.AutoFilter(1, "1", ..,..,..);
filteredRange = range.specialcells(..celltypeVisible, ..);
In this code, filteredRange size is always 1 row.