Exportieren Sie in Excel Head Row -Formatfilter ⇐ C#

[Anonymous]

Sagen Sie mir, wie ich die Filteroption wie im Screenshot zur Kopfreihe hinzufügt? Verwenden Sie Visual Studio, SDK documentFormat.openxml .

Code: Select all

 WorksheetPart worksheetPart = workbookPart.AddNewPart();
var sheetData = new SheetData();
worksheetPart.Worksheet = new Worksheet(sheetData);

Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart),
SheetId = sheetId, Name = "Equipment" };
sheets.AppendChild(sheet);

Row headerRow = new Row();

InsertCell(headerRow, 1, "Column 10", CellValues.String);
InsertCell(headerRow, 2, "Column 20", CellValues.String);