private void FinalizeSheet()
{
if (writer != null)
{
writer.WriteEndElement(); // end of SheetData
writer.WriteElement(new AutoFilter {
Reference = $"A1:{OXLHelper.GetColumnLetter(ColumnCount - 1)}{RowCount}"
});
writer.WriteEndElement(); // end of Worksheet
}
}
private void CreateAutoFilterDefinedName()
{
var workbook = document.WorkbookPart.Workbook;
if (workbook.DefinedNames == null)
{
workbook.DefinedNames = new DefinedNames();
}
var lastColumnIndex = rowsWriter.ColumnCount - 1;
var lastColumnLetter = OXLHelper.GetColumnLetter(lastColumnIndex);
var rowCount = rowsWriter.RowCount;
var definedName = new DefinedName($"'{sheetName}'!$A$1:${lastColumnLetter}${rowCount}")
{
Name = "_xlnm._FilterDatabase",
LocalSheetId = 0,
Hidden = true
};
workbook.DefinedNames.AppendChild(definedName);
}