16,554
社区成员
发帖
与我相关
我的任务
分享
'ExportExcel过程功能:将数据导出生成Excel文件
Public Sub ExportExcel(ByVal strOutput As String, ByVal Filename As String)
System.Windows.Forms.Clipboard.SetDataObject(strOutput)
'Create a workbook in Excel.
Dim oExcel As Object
Dim oBook As Object
oExcel = CreateObject("Excel.Application")
oBook = oExcel.Workbooks.Add
'Paste the data.
oBook.Worksheets(1).Range("A1").Select()
oBook.Worksheets(1).Paste()
'oBook.Worksheets(1).Range(oBook.Worksheets(1).Columns("A"), oBook.Worksheets(1).Columns("M")).AutoFit()
'Save the workbook and quit Excel.
oBook.SaveAs(Filename)
oBook = Nothing
oExcel.Quit()
oExcel = Nothing
End Sub
Private Shared Sub KillExcelProcess()
Dim processes As Process() = Process.GetProcessesByName("EXCEL")
Dim process As Process
For Each process In processes
process.Kill
Next
End Sub
[/quote]
你好,我试过了这段代码,没有用,问题依旧,我是通过剪贴板把数据复制到excel的,可能要结束的进程名称中不包含"excel"这个字符串
Private Shared Sub KillExcelProcess()
Dim processes As Process() = Process.GetProcessesByName("EXCEL")
Dim process As Process
For Each process In processes
process.Kill
Next
End Sub