关于使用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