vb.net的例子,已经测试:
1)首先在项目中添加引用,注册OWC,就是楼上说的。
2)使用如下代码将datagrid导入EXCEL
Dim xlsheet As New OWC.SpreadsheetClass()
Dim selectconn As String = "select * from table"
Dim comsql As OleDb.OleDbCommand = New OleDb.OleDbCommand(selectconn, MyConn)
MyConn.Open()
Dim comsqlreader As OleDb.OleDbDataReader = comsql.ExecuteReader
Dim numcols As Integer = comsqlreader.FieldCount
Dim row As Integer = 1
Dim i As Integer
While comsqlreader.Read
For i = 0 To numcols - 1
xlsheet.ActiveCell.Cells(row, i + 1) = comsqlreader.GetValue(i).ToString()
Next
row += 1
End While