对Excel的操作时很频繁的,用哪种方法更合适,那就看系统的应用了。下面应用odbc读写Excel特别方便、简单。便随笔随笔更多好方法还望高手留笔
首先当然要引用using System.Data.Odbc 名称空间。
具体读Excel方法:
1
OdbcConnection Connnection
=
new
OdbcConnection();
2
Connnection.ConnectionString
=
"
Driver={Microsoft Excel Driver (*.xls)};DBQ=
"
+
itemFile;
3
OdbcCommand cmd
=
new
OdbcCommand();
4
cmd.Connection
=
Connnection;
5
cmd.CommandText
=
"
SELECT * FROM [Sheet1$]
"
;
6
OdbcDataAdapter oda
=
new
OdbcDataAdapter(cmd);
7
DataTable dt
=
new
DataTable();
8
oda.Fill(dt);
9
Connnection.Close();
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
具体写Excel 方法:
1
OdbcConnection Connnection
=
new
OdbcConnection();
2
Connnection.ConnectionString
=
"
Driver={Microsoft Excel Driver (*.xls)};Readonly=0;DBQ=
"
+
itemFile;
3
OdbcCommand cmd
=
new
OdbcCommand();
4
cmd.Connection
=
Connnection;
5
Connnection.Open();
6
cmd.CommandText
=
"
Insert into [Sheet1$] (name,password) values ('admin','admin')
"
;
7
cmd.ExecuteNonQuery();
8
Connnection.Close();
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
如果更新的话,CommandText值改成Update语句就可以了。
觉得值得注意的地方:执行写操作时,ConnectionString要设置Excel文件可写。