Disable the Filter RSS

• • Reply
  

  suresh.pydi

  Member

  135 Points

  185 Posts

  Disable the Filter

  Nov 29, 2011 10:41 AM|LINK

  Hi,

   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

  Regards,

  Naresh.Pydi

• • Reply
  

  abiruban

  All-Star

  16002 Points

  2731 Posts

  Re: Disable the Filter

  Nov 29, 2011 10:52 AM|LINK

  Hi

  try this it may be help us

  http://support.microsoft.com/kb/162059

  Please excuse my poor/bad English
  ***DON'T FORGET TO CLICK “MARK AS ANSWER” ON THE POST IF HELPED YOU.
  
• • Reply
  

  Qi Wu - MSFT

  Contributor

  5794 Points

  677 Posts

  Re: Disable the Filter

  Dec 02, 2011 06:02 AM|LINK

  Hi,

  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.

  http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.autofilter(v=vs.80).aspx

  You can also remove filters manually.

  http://office.microsoft.com/en-us/excel-help/remove-filters-HP005202049.aspx

  Please mark the replies as answers if they help or unmark if not.
  If you have any feedback about my replies, please contact msdnmg@microsoft.com
  Microsoft One Code Framework
  
  • Marked as answer by Qi Wu - MSFT on Dec 06, 2011 05:10 AM