我正在使用C#的DocumentFormat.OpenXML。如何隐藏特定的列?部分代码如下:
using (SpreadsheetDocument sDocument = SpreadsheetDocument.Open(resultFileName, true))
{
WorkbookPart workbookPart = sDocument.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
var relId = workbookPart.GetIdOfPart(worksheetPart);
GenerateWorksheetPartContent(worksheetPart, data, templateSheet);
var columns = worksheetPart.Worksheet.Descendants<Column>(); <-- Empty
int[] colomnsToHide = new int[] { 3, 8, 16, 17, 18 };
foreach (int i in colomnsToHide)
{
columns[i].Hidden = true;
}
}
templateSheet - xlsx-template中的SheetData。
data - 要插入的数据。
有任何建议吗?
public Worksheet GenerateWorksheet() { Worksheet worksheet1 = new Worksheet(); .... Columns columns1 = new Columns(); .... worksheet1.Append(columns1); .... return worksheet1; }
- Phoenix