Free Support Forum - aspose.com

Print excel

Hi,

Is there a way to print aspose.excel??? We developed a vb.net code which will create an aspose excel report, save it, then use MS-excel to open an aspose.excel, then printout to a default printer. The problem is EXCEL.EXE will still hang in the task manager after all the app terminates.

In the monthend, we run a VB6 app which will generate about 200 reports. Which also means it will run the VB.net code 200 times. It’s killing everything with that number of EXCEL.EXE hanging there. Any clue how we can solve this?

Dim temporaryXlsFile As System.IO.FileInfo = New System.IO.FileInfo(System.IO.Path.Combine(System.IO.Path.GetTempPath(), outputReportName & “.xls”))
excelApp.Save(temporaryXlsFile.FullName)
temporaryXlsFile.Refresh()

’ print the xls file
Dim xla As New Excel.Application
Try
Dim xlb As Excel.Workbook = xla.Workbooks.Open(temporaryXlsFile.FullName, False, False)
xlb.PrintOut()
xlb.Close(False)
ReleaseCOMObject(xlb)
Finally
Try
If Not xla Is Nothing Then
xla.Quit()
End If
Catch ex As System.Exception
System.Diagnostics.Trace.WriteLine(ex, “HiddenException”)
Finally
ReleaseCOMObject(xla)
End Try
End Try

Aspose.Excel doesn't support to print excel files for it's too complex.


Which version of MS Excel are you using? You can try Excel2003.

I am using MS-Excel 2003(11.6355.6360) SP1, which is still giving me all the excel.exe hanging things.

such a pain…