Excel对NET来说可以当作一个数据表，不用使用控件操作。

Dim DS As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Dim MyConnection As System.Data.OleDb.OleDbConnection
pathsheet = "Excel表名$"
path = Dir(路径加文件名)
MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [" & pathsheet & "]", MyConnection)
DS = New System.Data.DataSet()
MyCommand.Fill(DS)
这样就可以读取一个Excel表

[此贴子已经被作者于2007-9-11 8:12:09编辑过]