none
How to remove blank from Value filter RRS feed

  • Question

  • Hello,

       By using Microsoft.Interop.Office.Excel.dll (12.0.0.0), I want to programetically   uncheck(or remove)   (blank) from the value filter once I populate the data from dataset.

      I am using an excel template (.xltx) file in that data is populating in the third worksheet, and in the first sheet i am using a pivot table.  From the pivot table i need to uncheck (blank) filter programetically for a particular column.

       Is there any way to do this ?

    Friday, September 27, 2013 7:18 AM

All replies

  • Hi,

    You can unselect the blank from Name field by using below script

    With ActiveSheet.PivotTables("PivotTable2").PivotFields("Name")
            .PivotItems("(blank)").Visible = False
    End With

    Emac Eeshan

    Friday, September 27, 2013 10:52 AM
  • Hi,

       I am using C# (2.0)  for development.

       I am not getting the method PivotFields("Name").

       Please advice

    Friday, September 27, 2013 11:28 AM