现在的位置: 首页 > 综合 > 正文

vb.net操作xls文件,并向其中加入图片

2012年09月18日 ⁄ 综合 ⁄ 共 592字 ⁄ 字号 评论关闭

    Public Function InsertPicture() As String
        
 

         Dim oExcel As New Microsoft.Office.Interop.Excel.Application

        Dim obook As Microsoft.Office.Interop.Excel.Workbooks

        Dim oSheet As Microsoft.Office.Interop.Excel.Sheets

        Dim miss As System.Reflection.Missing

        miss = System.Reflection.Missing.Value

        oExcel.Visible = True

        oExcel.DisplayAlerts = False

        obook = oExcel.Workbooks.Open("c:\aa.xls", miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss)

        oSheet = obook.Item(1).ActiveSheet.Pictures.Insert("c:\aa.jpg").Select()

 

        Return ""

    End Function

抱歉!评论已关闭.