使用c#选择多个excel范围

using Excel = Microsoft.Office.Interop.Excel;

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

Excel.Worksheet worksheet = workbook.Worksheets[1]; // 假设要操作第一个工作表

Excel.Range range1 = worksheet.Range["A1:B5"]; // 选择A1到B5范围
Excel.Range range2 = worksheet.Range["C1:D5"]; // 选择C1到D5范围

// 读取数据
object[,] data = range1.Value;
for (int row = 1; row <= range1.Rows.Count; row++)
{
    for (int column = 1; column <= range1.Columns.Count; column++)
    {
        Console.WriteLine(data[row, column]);
    }
}

// 写入数据
range2.Value = new object[,] { { "Value1", "Value2" }, { "Value3", "Value4" }, { "Value5", "Value6" }, { "Value7", "Value8" }, { "Value9", "Value10" } };

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();