在excel文档与C#的特定工作表中创建新行

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("path_to_excel_file");

Excel.Worksheet worksheet = workbook.Worksheets["sheet_name"];

int rowCount = worksheet.UsedRange.Rows.Count;

Excel.Range range = worksheet.Range["A" + (rowCount + 1).ToString(), "A" + (rowCount + 1).ToString()];
range.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown);

worksheet.Cells[rowCount + 1, 1] = "Value1";
worksheet.Cells[rowCount + 1, 2] = "Value2";
// 继续设置其他列的值

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