请详细说明VB.NET要如何将数据导出到EXCEL上(最好贴出代码例子)
各位师兄好:
想请教在VB.NET中,如何将一个数据集的内容数据导出到EXCEL上?
比如:
Protected WithEvents dbConn As New System.Data.OleDb.OleDbConnection
Protected WithEvents dbCom As New System.Data.OleDb.OleDbCommand
dbConn.ConnectionString = ...........
dbConn.Open()
Dim sqlStr As String
Dim myreader As System.Data.OleDb.OleDbDataReader
dbCom.Connection = dbConn
sqlStr = "select * from test "
dbCom.CommandText = sqlStr
Try
myreader = dbCom.ExecuteReader
'这里已经得到需要的记录集数据了,如何将其导出到EXCEL上呢?
Catch
Finally
dbConn.Close()
希望贴出详细代码.就按这个小例子来写就可以了.还有之前应该引用哪些类,
也请说明,谢谢赐教.