Export to Excel with filter

Export to Excel with filter

Posted by: grapecity on 11 December 2017, 7:47 pm EST

• 

  grapecity

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 December 2017, 7:47 pm EST

  I use this to set filter in my spread.
  
  Is it possible to keep this filter in the exported file to excel?

  FpSpread1.ActiveSheet.ClearRowFilter()
              Dim i As Integer
              Do While (i < FpSpread1.ActiveSheet.ColumnCount)
                  FpSpread1.ActiveSheet.Columns(i).AllowAutoFilter = False
                  FpSpread1.ActiveSheet.Columns(i).AllowAutoFilter = True
                  i = (i + 1)
              Loop
  
              FpSpread1.ActiveSheet.AutoFilterMode = AutoFilterMode.EnhancedContextMenu
  
              FpSpread1.ActiveSheet.SetColumnShowSortIndicator(6, True)
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 14 December 2017, 3:32 am EST

  Hello,

  You can save the filtered data to Excel as it is using the “SaveAsFiltered” SaveExcelFlag. Excel uses it own filter which you can enable from within excel.

  Thanks,
  
  Deepak Sharma