7,763
社区成员
发帖
与我相关
我的任务
分享
On Error Resume Next
Dim i As Long, j As Long
dim xlsApp as object
Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
xlsApp.Workbooks.Add
xlsApp.Sheets("Sheet1").Select
DataGrid1.Row = 0: i = 1
Dim rs As ADODB.Recordset
Set rs = DataGrid1.DataSource
If Not rs.EOF Then rs.MoveFirst
Do While Not rs.EOF
For j = 1 To DataGrid1.Columns.Count
xlsApp.Cells(i, j) = rs.Fields(j - 1)
Next
i = i + 1
rs.MoveNext
Loop
' xlsApp.ActiveSheet.Range("A1").CopyFromRecordset DataGrid1.DataSource
' xlsApp.ActiveSheet.Range("A1").CopyFromRecordset Adodc1.Recordset
If xlsApp.ActiveWorkbook.Saved = False Then
xlsApp.ActiveWorkbook.SaveAs "C:\0.xls"
End If
xlsApp.Quit
Set xlsApp = Nothing
MsgBox "导出完毕~ "
大概就是这么个样子了,注释部分快速导入excel Dim rs As ADODB.Recordset
Set rs = DataGrid1.DataSource
If Not rs.EOF Then rs.MoveFirst
Do While Not rs.EOF
For j = 1 To DataGrid1.Columns.Count
Print rs.Fields(j - 1) '打印格式及位置自己调
Next
i = i + 1
rs.MoveNext
Loop