asp.net Microsoft.Office.Interop.Excel导出Excel

关于使用Microsoft.Office.Interop.Excel类导出Excel文件，做单元格合并或者是获取单元格对象

asp.net 2.0

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wBook = app.Workbooks.Add(true);
Microsoft.Office.Interop.Excel.Worksheet wSheet = wBook.Worksheets[1] as Microsoft.Office.Interop.Excel.Worksheet;
Microsoft.Office.Interop.Excel.Range range2 = wSheet.get_Range[wSheet.Cells[2, 1], wSheet.Cells[2, 7]];

asp.net 4.0

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wBook = app.Workbooks.Add(true);
Microsoft.Office.Interop.Excel.Worksheet wSheet = wBook.Worksheets[1] as Microsoft.Office.Interop.Excel.Worksheet;
Microsoft.Office.Interop.Excel.Range range2 = wSheet.Range[wSheet.Cells[2, 1], wSheet.Cells[2, 7]];

主要还是Range方法变异了。

在asp.net 4.0 调用get_Range 异常：wsheet对象不存在get_Range函数

环境：VS2010， Office 2013