使用oledb读取excel表
2024-08-23 11:46:29
string path = "C:\\Users\\aaa\\Desktop\\aa.xls";
string conn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + path + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'"; OleDbConnection oleCon = new OleDbConnection(conn); oleCon.Open(); string Sql = "select * from [Sheet1$]"; OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, oleCon); DataSet ds = new DataSet(); mycommand.Fill(ds, "[Sheet1$]"); oleCon.Close(); int count = ds.Tables["[Sheet1$]"].Rows.Count; MessageBox.Show(count+""); for (int i = ; i < count; i++)
{ string tUserID, tUserName, tDept, tEmail, tLeader, tAngent; tUserID = ds.Tables["[Sheet1$]"].Rows[i][].ToString().Trim(); tUserName = ds.Tables["[Sheet1$]"].Rows[i][].ToString().Trim();
tDept = ds.Tables["[Sheet1$]"].Rows[i][].ToString().Trim(); MessageBox.Show(tUserID + "," + tUserName + "," + tDept); }
最新文章
- 【转】php Thread Safe(线程安全)和None Thread Safe(NTS,非 线程安全)之分
- .net 4.0 ValidateRequest=";false"; 无效
- header
- navigator.sendBeancon方法简介
- NAT123 解决80端口被封的问题
- hdu 1069
- spring_150803_component
- -_-#【JS】defer / async
- 赵雅智_ListView_BaseAdapter
- <;<;java 并发编程>;>;第七章:取消和关闭
- C# DateTimePicker控件如何精确设置显示时分秒
- webdynpro的select_option示例
- vbs打包exe工具
- 干货——基于Nop的精简版开发框架(附源码)
- C#基础知识-XML介绍及基本操作(十)
- sqlserver 取日期年份月份
- java中位运算
- Fedora 24系统基本命令
- onkeyup+onafterpaste 只能输入数字和小数点
- 《C++数据结构-快速拾遗》 手写链表