Partager via

ChartSheetBase.SetBackgroundPicture(String) Method

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Sets the background graphic for a ChartSheetBase.

public:
 void SetBackgroundPicture(System::String ^ filename);
public void SetBackgroundPicture (string filename);
member this.SetBackgroundPicture : string -> unit
Public Sub SetBackgroundPicture (filename As String)

Parameters

filename
String

The name of the graphic file.

Examples

The following code example uses the SetBackgroundPicture method to set the background of the current Microsoft.Office.Tools.Excel.ChartSheetBase to an image file.

private void ApplyNewBackground()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    string backgroundFilePath = @"C:\image1.jpg";

    if (System.IO.File.Exists(backgroundFilePath))
    {
        this.SetBackgroundPicture(@"C:\image1.jpg");
    }
    else
    {
        MessageBox.Show(@"The file image1.jpg does not exist at C:\.");
    }
}

Private Sub ApplyNewBackground()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn

    Dim backgroundFilePath As String = "C:\image1.jpg"
    If System.IO.File.Exists(backgroundFilePath) Then
        Me.SetBackgroundPicture("C:\image1.jpg")
    Else
        MsgBox("The file image1.jpg does not exist at C:\")
    End If
End Sub

Applies to