我刚接触Openxml,正在尝试使用它创建xlsx文件。我想在Excel文件中的不同单元格文本中应用不同的字体和颜色。我正在使用下面的代码创建xlsx文件,但无法实现字体和颜色的变化。
SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create("E:\\Word9.xlsx", SpreadsheetDocumentType.Workbook);
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets());
int i = 1;
while (i <= 5)
{
Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = (UInt32)i, Name = "mySheet" + i.ToString() };
for (int ii = 1; ii <= 5; ii++)
{
Row row1 = new Row();
sheets.AppendChild(row1);
Cell cll = new Cell(new InlineString(new DocumentFormat.OpenXml.Spreadsheet.Text("qqqqqq"))) { DataType = CellValues.InlineString };
row1.AppendChild(cll);
}
sheets.Append(sheet);
i++;
}
workbookpart.Workbook.Save();
有人知道如何将字体和颜色应用于不同的单元格吗?