VB.NET-INFORMATIONS.COM

<< Back To - VB.NET Excel 2007 Tutorials

Insert Background Pictures in Excel 2007 from VB.NET

Vb.Net Help      Crystal Reports      Excel


The following VB.NET program shows , how to insert a background picture in Excel 2007 . For inserting a background picture in Excel 2007 we hav to call the SetBackgroundPicture mthod in worksheet .

Syntax : SetBackgroundPicture(ByVal Filename As String)

Filename : The background picture filename .

excel_background.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")

        'set back ground
        'replace your background picture to xl_pic.JPG
        xlWorkSheet.SetBackgroundPicture("C:\xl_pic.JPG")

        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 background 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 Picture in Excel 2007 through programing on 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