如何使用c#在excel表格数据表中添加空行

using Microsoft.Office.Interop.Excel;
//...

Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Open("your_excel_file_path.xlsx");
Worksheet worksheet = workbook.Worksheets[1];

int rowIndex = 2; // 假设要在第2行后插入空行
Range targetRow = (Range)worksheet.Rows[rowIndex];
targetRow.Insert(XlInsertShiftDirection.xlShiftDown, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

workbook.Save();
workbook.Close();
excelApp.Quit();

// 释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);

worksheet = null;
workbook = null;
excelApp = null;

GC.Collect();

using Microsoft.Office.Interop.Excel;
//...

Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Add();
Worksheet worksheet = workbook.Worksheets[1];

// 插入空行的操作和上述步骤相同

// 保存并关闭Excel文件的步骤也与上述相同