Office Open XMl SDK 将数字写入工作表

csharp
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
public void CreateAndWriteToWorksheet(string filePath)
{
    // Create a new Excel file
    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook))
    {
        // Add a WorkbookPart to the document
        WorkbookPart workbookPart = spreadsheetDocument.AddWorkbookPart();
        workbookPart.Workbook = new Workbook();
        // Add a WorksheetPart to the WorkbookPart
        WorksheetPart worksheetPart = workbookPart.AddNewPart();
        worksheetPart.Worksheet = new Worksheet(new SheetData());
        // Add a Sheets element to the Workbook
        Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets());
        // Append a new worksheet and associate it with the Workbook
        Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" };
        sheets.Append(sheet);
        // Save the Workbook
        spreadsheetDocument.WorkbookPart.Workbook.Save();
        // Write number to the worksheet
        Worksheet worksheet = worksheetPart.Worksheet;
        Cell cell = worksheet.Descendants().FirstOrDefault(c => c.CellReference == "A1");
        if (cell != null)
        {
            cell.CellValue = new CellValue("10");
            cell.DataType = new EnumValue(CellValues.Number);
        }
        worksheetPart.Worksheet.Save();
    }
}