VB.NET-INFORMATIONS.COM

<< Back To - VB.NET Excel 2007 Tutorials

Insert Pictures in Excel 2007 from VB.NET 2005

Vb.Net Help      Crystal Reports      Excel


The following VB.NET program shows , how to insert a picture in Excel 2007 . For inserting a picture in Excel 2007 we hav to call the AddPicture method. For that you have to specify PictureName with path , Left , Top , Width and Height.

excel_picture_insert.JPG

VB.NET Source Code

Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, _
                ByVal e As System.EventArgs) Handles Button1.Click

        Dim xlApp As Excel.Application
        Dim xlWorkBook As Excel.Workbook
        Dim xlWorkSheet As Excel.Worksheet
        Dim misValue As Object = System.Reflection.Missing.Value

        xlApp = New Excel.ApplicationClass
        xlWorkBook = xlApp.Workbooks.Add(misValue)
        xlWorkSheet = xlWorkBook.Sheets("sheet1")

        'add some text
        xlWorkSheet.Cells(1, 1) = "http://vb.net-informations.com"
        xlWorkSheet.Cells(2, 1) = "Adding picture in Excel File"

        'replace you picture to xl_pic.JPG

        xlWorkSheet.Shapes.AddPicture("C:\xl_pic.JPG", _
             Microsoft.Office.Core.MsoTriState.msoFalse, _
             Microsoft.Office.Core.MsoTriState.msoCTrue, 50, 50, 300, 45)

        xlWorkSheet.SaveAs("C:\vbexcel.xlsx")

        xlWorkBook.Close()
        xlApp.Quit()

        releaseObject(xlApp)
        releaseObject(xlWorkBook)
        releaseObject(xlWorkSheet)

        MsgBox("Excel file created , you can find the file c:\")
    End Sub

    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

End Class
When you execute this program , you will get an Excel file (C:\vbexcel.xlsx) with insert the picture.

VB.NET 2005 Excel 2007 Related Contents
How to create an Excel 2007 file in VB.NET 2005
How to open or read an existing Excel 2007 file in VB.NET 2005
How to read entire worksheet in an Excel workbook
How to Format Excel 2007 Page in VB.NET
How to insert a background Picture in Excel 2007 through VB.NET 2005
How to create a Chart in Excel 2007 in VB.NET
How to export a Chart in Excel 2007 as Picture file from VB.NET
How to Excel 2007 Chart in VB.NET Picture Box
How to Excel 2007 DataBar in VB.NET
How to Excel 2007 Data Validation Input Message
How to read data from excel using OLEDB
How to insert cell data in an Excel file using OLEDB
How to update cell data in an Excel file using OLEDB
How to export from database to excel
How to export from DataGridView to excel

Search here for more Vb.Net Source Code :



    Categories

    HOME
    VB.NET

 
 
 
   













  |  Home   |  SiteMap   |  About   |
net-informations.com (C) 2008 All Rights Reserved