使用具有指定列的OpenXml在Excel中插入新行

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

public void InsertNewRow(string filePath, string sheetName, int rowIndex, string[] rowData)
{
    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, true))
    {
        WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
        Sheet sheet = workbookPart.Workbook.Descendants<Sheet>().FirstOrDefault(s => s.Name == sheetName);
        
        if (sheet != null)
        {
            WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(sheet.Id);
            SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();
            
            // 创建新行
            Row newRow = new Row() { RowIndex = (uint)rowIndex };
            
            // 插入新行到指定位置
            sheetData.InsertBefore(newRow, sheetData.Elements<Row>().FirstOrDefault(r => r.RowIndex > rowIndex));
            
            // 在新行中插入数据
            for (int i = 0; i < rowData.Length; i++)
            {
                Cell newCell = new Cell() { CellReference = GetCellReference(i, rowIndex) };
                newCell.CellValue = new CellValue(rowData[i]);
                newCell.DataType = new EnumValue<CellValues>(CellValues.String);
                
                newRow.InsertAt(newCell, i);
            }
            
            // 更新行索引
            foreach (Row row in sheetData.Elements<Row>())
            {
                if (row.RowIndex > rowIndex)
                {
                    row.RowIndex++;
                }
            }
            
            worksheetPart.Worksheet.Save();
        }
    }
}

private string GetCellReference(int columnIndex, int rowIndex)
{
    int dividend = columnIndex + 1;
    string columnName = string.Empty;
    
    while (dividend > 0)
    {
        int modulo = (dividend - 1) % 26;
        columnName = Convert.ToChar(65 + modulo) + columnName;
        dividend = (dividend - modulo) / 26;
    }
    
    return columnName + rowIndex;
}

string filePath = "path/to/excel.xlsx";
string sheetName = "Sheet1";
int rowIndex = 2;
string[] rowData = { "Value1", "Value2", "Value3" };

InsertNewRow(filePath, sheetName, rowIndex, rowData);