Excel表格转换为DataTable (VSTO)

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("Excel文件路径");
Excel.Worksheet worksheet = workbook.Worksheets[1];

Excel.Range range = worksheet.UsedRange;
DataTable dataTable = new DataTable();

for (int row = 1; row <= range.Rows.Count; row++)
{
    DataRow dataRow = null;
    if (row == 1)
    {
        // 添加列标题
        for (int column = 1; column <= range.Columns.Count; column++)
        {
            dataTable.Columns.Add((string)(range.Cells[row, column] as Excel.Range).Value);
        }
    }
    else
    {
        // 添加数据行
        dataRow = dataTable.NewRow();
        for (int column = 1; column <= range.Columns.Count; column++)
        {
            dataRow[column - 1] = (range.Cells[row, column] as Excel.Range).Value;
        }
        dataTable.Rows.Add(dataRow);
    }
}

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