Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 02, 2011 06:02 AM by Qi Wu - MSFT
Nov 29, 2011 10:41 AM|LINK
I am using Spreadsheet and I am saving the Data in Excel File. and I am opening Excel File like the below code
xlApp.Workbooks.Open(path) // Path means where I am saving the Excel file
But the issue is I need to Turn off the filters before Opening the Excel File
Anyone Please Help
Nov 29, 2011 10:52 AM|LINK
try this it may be help us
Dec 02, 2011 06:02 AM|LINK
You can set the AutoFilterMode property to false before you open the excel. For more details you can refer to the sample in the below link.
You can also remove filters manually.