[VB.NET]列印EXCEL

davidou 2015 年 04 月 08 日

要列印EXCEL需要寫的程式碼還蠻簡單的

首先要加入EXCEL的參考讓 VB看得懂EXCEL

專案>加入參考> 擴充功能>然後照下圖這樣選。

程式碼Imports Microsoft.Office.Interop
Public Class Receipt
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
Dim x1 As New Excel.Application
 
x1.Workbooks.Open(My.Computer.FileSystem.SpecialDirectories.Desktop & "\test1.xls") '測試用excel檔
 
x1.ActiveWorkbook.PrintOutEx()
 
x1.Quit()
 
x1 = Nothing
End Sub
End Class

程式碼
1 2 3 4 5 6 7 8 9 10 11 12 13 14	`Imports Microsoft.Office.Interop` `Public Class Receipt` `Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click` `Dim x1 As New Excel.Application` `x1.Workbooks.Open(My.Computer.FileSystem.SpecialDirectories.Desktop & "\test1.xls") '測試用excel檔` `x1.ActiveWorkbook.PrintOutEx()` `x1.Quit()` `x1 = Nothing` `End Sub` `End Class`

Be the First to comment.

Davidou的 Blog

[VB.NET]列印EXCEL

Leave a Comment 取消回覆

About Author

DAVIDOU

近期文章

文章分類

最新回應

我的社群網路