写出C#批量读写excel单元格和逐个读写单元格的代码

批量读写excel单元格的代码如下：

using Microsoft.Office.Interop.Excel;

public class ExcelManager
{
    private Application _excelApp;
    private Workbook _workbook;
    private Worksheet _worksheet;

    public ExcelManager(string filePath)
    {
        _excelApp = new Application();
        _workbook = _excelApp.Workbooks.Open(filePath);
        _worksheet = _workbook.Sheets[1];
    }

    public void WriteRange(string range, object[,] values)
    {
        Range excelRange = _worksheet.Range[range];
        excelRange.Value = values;
    }

    public object[,] ReadRange(string range)
    {
        Range excelRange = _worksheet.Range[range];
        return excelRange.Value;
    }

    public void Save()
    {
        _workbook.Save();
    }

    public void Close()
    {
        _workbook.Close();
        _excelApp.Quit();
    }
}

逐个读写excel单元格的代码如下：

using Microsoft.Office.Interop.Excel;

public class ExcelManager
{
    private Application _excelApp;
    private Workbook _workbook;
    private Worksheet _worksheet;

    public ExcelManager(string filePath)
    {
        _excelApp = new Application();
        _workbook = _excelApp.Workbooks.Open(filePath);
        _worksheet = _workbook.Sheets[1];
    }

    public void WriteCell(int row, int column, object value)
    {
        Range excelRange = _worksheet.Cells[row, column];
        excelRange.Value = value;
    }

    public object ReadCell(int row, int column)
    {
        Range excelRange = _worksheet.Cells[row, column];
        return excelRange.Value;
    }

    public void Save()
    {
        _workbook.Save();
    }

    public void Close()
    {
        _workbook.Close();
        _excelApp.Quit();
    }
}

上述代码使用了Microsoft.Office.Interop.Excel库来操作Excel文件。请确保你的项目中已经引用了该库