在C#应用程序中隐藏/取消隐藏Excel中的行

using Excel = Microsoft.Office.Interop.Excel;

// 隐藏行
public void HideRows(string filePath, string sheetName, int startRow, int endRow)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open(filePath);
    Excel.Worksheet worksheet = workbook.Sheets[sheetName];

    Excel.Range range = worksheet.Rows[startRow + ":" + endRow];
    range.EntireRow.Hidden = true;

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

// 取消隐藏行
public void UnhideRows(string filePath, string sheetName, int startRow, int endRow)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open(filePath);
    Excel.Worksheet worksheet = workbook.Sheets[sheetName];

    Excel.Range range = worksheet.Rows[startRow + ":" + endRow];
    range.EntireRow.Hidden = false;

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