ChartSheet.SetBackgroundPicture Method
Sets the background graphic for a Microsoft.Office.Tools.Excel.ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Sub SetBackgroundPicture ( _
Filename As String _
)
void SetBackgroundPicture(
string Filename
)
Parameters
Filename
Type: System.StringThe 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.ChartSheet to an image file.
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
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:\.");
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.