C#Open Xml SDK 2.0电子表格设置单元格日期时间格式

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

public class ExcelHelper
{
    public static void SetCellDateTimeFormat(string filePath, string sheetName, string cellReference, string dateTimeFormat)
    {
        using (SpreadsheetDocument document = SpreadsheetDocument.Open(filePath, true))
        {
            WorkbookPart workbookPart = document.WorkbookPart;
            Sheet sheet = workbookPart.Workbook.Descendants<Sheet>().FirstOrDefault(s => s.Name == sheetName);
            WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(sheet.Id);

            Cell cell = worksheetPart.Worksheet.Descendants<Cell>().FirstOrDefault(c => c.CellReference == cellReference);
            if (cell != null)
            {
                // 创建一个新的样式对象
                CellFormats cellFormats = workbookPart.WorkbookStylesPart.Stylesheet.CellFormats;
                CellFormat cellFormat = new CellFormat();

                // 设置日期时间格式属性
                NumberingFormat numberingFormat = new NumberingFormat
                {
                    NumberFormatId = UInt32Value.FromUInt32(0),
                    FormatCode = StringValue.FromString(dateTimeFormat)
                };
                workbookPart.WorkbookStylesPart.Stylesheet.NumberingFormats.AppendChild(numberingFormat);

                cellFormat.NumberFormatId = UInt32Value.FromUInt32(0);
                cellFormat.ApplyNumberFormat = BooleanValue.FromBoolean(true);

                cellFormats.AppendChild(cellFormat);
                cellFormats.Count = UInt32Value.FromUInt32((uint)cellFormats.ChildElements.Count);

                // 将样式应用到单元格
                cell.StyleIndex = UInt32Value.FromUInt32((uint)cellFormats.ChildElements.Count - 1);
                worksheetPart.Worksheet.Save();
            }
        }
    }
}

ExcelHelper.SetCellDateTimeFormat("path/to/excel.xlsx", "Sheet1", "A1", "yyyy-mm-dd");