Open XML SDK将双精度值写入Excel单元格

using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

public void WriteDoubleValueToExcelCell(string filePath, string sheetName, int rowIndex, int columnIndex, double value)
{
    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, true))
    {
        WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
        Sheet sheet = workbookPart.Workbook.Descendants<Sheet>().FirstOrDefault(s => s.Name == sheetName);
        WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(sheet.Id);

        Cell cell = GetOrCreateCell(worksheetPart.Worksheet, columnIndex, rowIndex);
        cell.DataType = CellValues.Number;
        cell.CellValue = new CellValue(value.ToString());

        worksheetPart.Worksheet.Save();
    }
}

private Cell GetOrCreateCell(Worksheet worksheet, int columnIndex, int rowIndex)
{
    Row row = worksheet.GetOrCreateRow(rowIndex);
    Cell cell = row.GetOrCreateCell(columnIndex);
    return cell;
}

private Row GetOrCreateRow(this Worksheet worksheet, int rowIndex)
{
    Row row = worksheet.GetFirstChild<SheetData>().Elements<Row>().FirstOrDefault(r => r.RowIndex == rowIndex);
    if (row == null)
    {
        row = new Row() { RowIndex = rowIndex };
        worksheet.GetFirstChild<SheetData>().Append(row);
    }
    return row;
}

private Cell GetOrCreateCell(this Row row, int columnIndex)
{
    Cell cell = row.Elements<Cell>().FirstOrDefault(c => c.CellReference.Value == GetCellReference(columnIndex, row.RowIndex));
    if (cell == null)
    {
        cell = new Cell() { CellReference = GetCellReference(columnIndex, row.RowIndex) };
        row.Append(cell);
    }
    return cell;
}

private string GetCellReference(int columnIndex, int rowIndex)
{
    return $"{GetColumnName(columnIndex)}{rowIndex}";
}

private string GetColumnName(int columnIndex)
{
    int dividend = columnIndex;
    string columnName = string.Empty;
    int modulo;

    while (dividend > 0)
    {
        modulo = (dividend - 1) % 26;
        columnName = Convert.ToChar(65 + modulo) + columnName;
        dividend = (dividend - modulo) / 26;
    }

    return columnName;
}