VB.Net-Informations.com
   Home      .Net Framework      VB.NET      C#                                                                      About


  Insert Pictures in Excel 2007 from VB.NET 2005

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 Download           Print Source Code
         Insert Pictures in Excel 2007 from VB.NET 2005 - Download
        
C# Tutorial

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


   Home      VB.NET      C#
VB.Net Related Topics
*     Microsoft .Net Framework Tutorials
*     VB.NET Language Basics Tutorials
*     VB.NET Program Flow Control Tutorials
*     VB.NET Collections Tutorials
*     VB.NET String Tutorials
*     VB.NET Files Tutorials
*     VB.NET Excel 2007 Tutorials
*     VB.NET Crystal Reports Tutorials
*     VB.NET Communications Tutorial
*     VB.NET ADO.NET Tutorial
*     ADO.NET Data Providers help and Tutorial
*     VB.NET ADO.NET Dataset Tutorial
*     ADO.NET DataAdapter and Dataset
*     VB.NET ADO.NET DataView Tutorial
*     VB.NET Remoting Tutorial
*     VB.NET XML Tutorial
*     VB.NET DataGridView Tutorial
   Home      VB.NET      C#
More Source Code :   
Mail to :  feedback@net-informations.com
  |  Home   |  VB.NET   |  C#   |  SiteMap   |  Terms of Use   |  About   |
net-informations.com (C) 2010
All Rights Reserved. All other trademarks are property of their respective owners.