如何在Excel中关闭自动筛选? [英] How to turn off Auto Filter in Excel?

问题描述

你好，
自我学习的另一个问题是我无法使用Google解决.请帮帮我.
我正在尝试读取Excel工作表，并且此工作表中的数据可能已过滤.所以我需要关闭过滤器并开始阅读.我使用下面的代码，但是这给了我AutoFilter方法一个异常(COMException)"Range类的AutoFilter方法失败".
请帮我解决这个问题.

Hello,
Just another problem while self learning i could not solve using google. Please help me out.
I am trying to read an Excel sheet and this possibly has data filtered in columns. So i need to turn off the filter and start reading it. I use the below code but then this gives me an exception(COMException)"AutoFilter method of Range class failed" at AutoFilter method .
Please help me out with this.

Excel.Range RemFil ;
RemFil = ExcelSheet.get_Range("A1", MissingObject);
RemFil.AutoFilter(MissingObject, MissingObject, Excel.XlAutoFilterOperator.xlOr, MissingObject, MissingObject);

推荐答案

在

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