近来需要用C#操作Excel表,网上找了一堆东东
先总结如下:
1 环境
window XP SP3
Visual Studio 2010 Ultimate X86
Office Excel 2003(在高级选项中选择安装Excel的.Net可编程性支持)
2 项目属性
winForm项目,FrameWork 3.5
需在项目中 添加引用=》COM =》Microsoft Excel 11.0 Object Library
3 代码
代码中引用using Microsoft.Office.Interop.Excel;
读Excel数据:
a) 直接读取Cell的值
Application oExcelApp = new Application();
Workbook oWorkbook = oExcelApp.Workbooks.Add(strFileName);
Worksheet oWorksheet = (Worksheet)oWorkbook.Worksheets[1];
//Worksheet oWorksheet = (Worksheet)oWorkbook.ActiveSheet;
string strCellName = "a1";
Range oRange = oWorksheet.get_Range(strCellName, Type.Missing);
string strCellVal = oRange.Value.ToString();
b)通过oledb读取
网上看到了这方面很好的博客文章(直接看他的吧^_^,我运行过,没问题)
注意:sql语句中的表名=worksheet名+“$”
http://www.liuwu.net/post/how-to-read-excel-with-c.aspx