Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click
daochu(DataGridView1)
End Sub Private Sub daochu(ByVal dataGridView As DataGridView)
Dim wapp As New Microsoft.Office.Interop.Excel.Application
Dim wsheet As Microsoft.Office.Interop.Excel.Worksheet
Dim wbook As Microsoft.Office.Interop.Excel.Workbook
On Error Resume Next
wapp.Visible = True
wbook = wapp.Workbooks.Add()
wsheet = wbook.ActiveSheet
Dim iX As Integer
Dim iY As Integer
Dim iC As Integer
For iC = 0 To dataGridView.Columns.Count - 1
wsheet.Cells(1, iC + 1).Value = dataGridView.Columns(iC).HeaderText
Next
For iX = 0 To dataGridView.Rows.Count - 1
For iY = 0 To dataGridView.Columns.Count - 1
wsheet.Cells(iX + 2, iY + 1).value = dataGridView(iY, iX).Value.ToString
Next
wbook.Close()
wapp.Quit()
Next
wsheet = Nothing
wbook = Nothing
wapp = Nothing
End Sub
daochu(DataGridView1)
End Sub Private Sub daochu(ByVal dataGridView As DataGridView)
Dim wapp As New Microsoft.Office.Interop.Excel.Application
Dim wsheet As Microsoft.Office.Interop.Excel.Worksheet
Dim wbook As Microsoft.Office.Interop.Excel.Workbook
On Error Resume Next
wapp.Visible = True
wbook = wapp.Workbooks.Add()
wsheet = wbook.ActiveSheet
Dim iX As Integer
Dim iY As Integer
Dim iC As Integer
For iC = 0 To dataGridView.Columns.Count - 1
wsheet.Cells(1, iC + 1).Value = dataGridView.Columns(iC).HeaderText
Next
For iX = 0 To dataGridView.Rows.Count - 1
For iY = 0 To dataGridView.Columns.Count - 1
wsheet.Cells(iX + 2, iY + 1).value = dataGridView(iY, iX).Value.ToString
Next
wbook.Close()
wapp.Quit()
Next
wsheet = Nothing
wbook = Nothing
wapp = Nothing
End Sub
解决方案 »
- VB实时截取窗体后面的图作为窗体背景
- 一段修改注册表的源程序 不能执行请帮忙 VB修改注册表的问题
- 关于查询
- 怎样设定datagrid或dbgrid的列数以及列标题
- API做的菜单热键怎么用啊。我是这样弄的,不过不行
- 150分在线跪等高手,关于vb6中的函数怎么给其他语言调用的问题。。。
- 怎样用VB得到邮件通讯录中的地址?
- Vb6.0中如何在报表里显示出记录号?以及如何让报表在”show”出来之前与数据库保持一致?
- dada report问题???
- *****一个非VB问题——用什么软件可以查看二进制文件、随机文件的数据结构?*****
- vb 写XML时的层次感问题 --- 希望大侠指点
- VB6.0 统计问题
wbook .Save
wbook .Close
wapp .Quit
Set wsheet = Nothing
Set wbook = Nothing
Set wapp = Nothing
wapp.Quit()
这2个怎么写到循环里面去了?
wsheet = Nothing
wbook = Nothing
wapp = Nothing
这三个句子前写不出SET
那两个写到循环啊,哎,因为找不到原因,我到处试的,才接触的VB,新买的书在自学
wapp.save()
wapp.Quit()
这些写在循环外面,加上段点,你单步调试一下看看wapp.quit以后你的execl退出了没有
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
obj = Nothing
Catch ex As Exception
obj = Nothing
Finally
GC.Collect()
End Try
End Sub
我加了这么一段后,进程顺利退出了,谢谢指导
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
obj = Nothing
Catch ex As Exception
obj = Nothing
Finally
GC.Collect()
End Try
End Sub
我加了这么一段后,进程顺利退出了,谢谢指导
Shell "taskkill /IM EXCEL.EXE",vbHide