C#-Excel-如何在自动筛选后删除可见行? [英] C# - Excel - How to delete visible rows after AutoFilter?

问题描述

我正在使用一个小的命令行工具来从Excel工作表中提取一些数据.

I´m working on a little commandline tool to extract some data from an excel sheet.

我想删除应用自动筛选后可见的所有行.

I want to delete all rows which are visible after applying an AutoFilter.

不幸的是，我只是不知道如何继续.经过一番搜索，我找不到适合我的答案.

Unfortunately, I just don´t know how to continue. After some searching, I did not find a working answer for me.

这是我到目前为止所获得的:

Here is what I´ve got so far:

        oXL = new Excel.Application();
        oXL.Visible = false;
        oWB = oXL.Workbooks.Open(source);
        oXS = (Excel.Worksheet)oWB.Sheets[1];

        Excel.Range filter = oXS.UsedRange;
        filter.AutoFilter(8, "<>text to filter");

如何删除过滤后显示的所有行?

How do I delete all rows which are shown after filtering?

谢谢.

CRowland

推荐答案

Excel.Range filter = XlSheet_1.UsedRange;
filter.AutoFilter(8, "<>text to filter");
filter.Delete(XlDeleteShiftDirection.xlShiftUp);

这篇关于C#-Excel-如何在自动筛选后删除可见行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！