vb.net借助剪貼板將圖片導入excel內
來源:懂視網
責編:小采
時間:2020-11-27 22:40:20
vb.net借助剪貼板將圖片導入excel內
vb.net借助剪貼板將圖片導入excel內: 代碼如下: Dim im as Image=Image.FromFile (C:/picture.bmp) '獲得Image System.Windows.Forms.Clipboard.SetDataObject(im, True) '復制到剪貼板 Dim xlApp As Excel.Application = New Excel.Appl
導讀vb.net借助剪貼板將圖片導入excel內: 代碼如下: Dim im as Image=Image.FromFile (C:/picture.bmp) '獲得Image System.Windows.Forms.Clipboard.SetDataObject(im, True) '復制到剪貼板 Dim xlApp As Excel.Application = New Excel.Appl

代碼如下:
Dim im as Image=Image.FromFile ("C:/picture.bmp") '獲得Image
System.Windows.Forms.Clipboard.SetDataObject(im, True) '復制到剪貼板
Dim xlApp As Excel.Application = New Excel.Application()
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlBook = xlApp.Workbooks().Add
xlSheet = xlBook.Worksheets("sheet1")
Dim range As Excel.Range = xlSheet.Range(xlApp.Cells(4, 1), xlApp.Cells(4, 1)) '粘貼圖片的位置
xlSheet.Paste(range, im) '將圖片插入Excel
聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
vb.net借助剪貼板將圖片導入excel內
vb.net借助剪貼板將圖片導入excel內: 代碼如下: Dim im as Image=Image.FromFile (C:/picture.bmp) '獲得Image System.Windows.Forms.Clipboard.SetDataObject(im, True) '復制到剪貼板 Dim xlApp As Excel.Application = New Excel.Appl