表格中的文本居中- OpenXML SDK

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

// 打开Excel文档
using (SpreadsheetDocument document = SpreadsheetDocument.Open("example.xlsx", true))
{
    // 获取工作表
    WorksheetPart worksheetPart = document.WorkbookPart.WorksheetParts.First();
    Worksheet worksheet = worksheetPart.Worksheet;

    // 获取表格
    SheetData sheetData = worksheet.GetFirstChild<SheetData>();

    // 获取表格中的单元格
    IEnumerable<Cell> cells = sheetData.Descendants<Cell>();

    // 设置单元格样式，将文本居中
    foreach (Cell cell in cells)
    {
        cell.StyleIndex = 1; // 样式索引，可以根据实际需求设置

        // 创建单元格样式
        CellFormats cellFormats = worksheetPart.WorkbookPart.WorkbookStylesPart.Stylesheet.CellFormats;
        CellFormat cellFormat = new CellFormat();
        cellFormat.Alignment = new Alignment() { Horizontal = HorizontalAlignmentValues.Center };

        // 添加单元格样式
        cellFormats.AppendChild(cellFormat);
        cellFormats.Count++;
    }

    // 保存修改后的Excel文档
    worksheetPart.Worksheet.Save();
}