public class AutoFilter 

using( var doc = Workbook.Create( "test.xlsx") )   // Creates a Workbook named “test.xlsx”.

 {

    var worksheetA = workbook.Worksheets[ 0 ];



    // Fill cells values.

    worksheetA.Rows[ 4 ].Cells[ 6 ].Value = "Fruits";

    worksheetA.Rows[ 5 ].Cells[ 6 ].Value = "Strawberry";

    worksheetA.Rows[ 6 ].Cells[ 6 ].Value = "Orange";

    worksheetA.Rows[ 7 ].Cells[ 6 ].Value = "Banana";

    worksheetA.Rows[ 8 ].Cells[ 6 ].Value = "Apple";

    worksheetA.Rows[ 4 ].Cells[ 7 ].Value = "Quantity";

    worksheetA.Rows[ 5 ].Cells[ 7 ].Value = 8;

    worksheetA.Rows[ 6 ].Cells[ 7 ].Value = 2;

    worksheetA.Rows[ 7 ].Cells[ 7 ].Value = 3;

    worksheetA.Rows[ 8 ].Cells[ 7 ].Value = 3;



    // Creates the formatted table from cell (4,6) to cell (8,7), using a medium theme, with the formatted header row displayed.

    worksheetA.Tables.Add( 4, 6, 8, 7, TableStyle.TableStyleMedium20, true );



    // Gets the first table of the Worksheet and removes the filtering buttons.

    worksheetA.Tables[ 0 ].AutoFilter.ShowFilterButton = false;



    doc.Save();

  }