How to disable autofilter in closedXml c#?

c# excel closedxml
CST RAIZE picture CST RAIZE · Dec 22, 2015 · Viewed 11.2k times · Source

I am facing a weird problem in closedXML library.

I am exporting a datatable to .xlsx (excel file) using closedXML library. By default, autofilter is enabled in the library.

I want to disable or remove the autofilter and export only the datatable.

Here is the code I tried but its not working

XLWorkbook wb = new XLWorkbook();
var ws = wb.Worksheets.Add("Test");
ws.Cell(1, 1).InsertTable(dataTable);
ws.AutoFilter.Enabled = false;
ws.Columns().AdjustToContents();
wb.SaveAs("Report.xlsx");

and I also tried

ws.AutoFilter.Clear();

Even the column wise clear filter is not working

ws.AutoFilter.Column(1).Clear();

Answer

Hamaresha picture Hamaresha · Dec 22, 2015

Try to use below code and it should work fine

ws.Tables.FirstOrDefault().ShowAutoFilter = false;

Related questions

How to make Excel wrap text in formula cell with ClosedXml

The problem is that the cell content is not wrapped, when that cell contains a formula referring to a cell with some long string. On CodePlex I found a thread on this issue and a simple code to see the …

Read More
Append to excel file with ClosedXML

I need to append new data to existing excel file created with ClosedXML. How can I append to an excel file using ClosedXML? How can I get the row number of the last record and append to that or is …

Read More
ClosedXML find last row number

I'm using ClosedXML with C# to modify an Excel workbook. I need to find the last row number used but .RowCount() counts how many rows are in the worksheet. So it is returning 1 million rows when there are only a …

Read More