Setting a Background Image for a Sheet

You can set an image in the background of the cells in the data area of the sheet. Depending on the size of the graphic and the size of the spreadsheet, the image may be repeated (tiled) over the entire sheet of cells, as shown in the following figure.

Sheet Background Image Example

For more information on setting an image in an individual cell, refer to Setting a Background Image to a Cell.

For more information on the image cell type, refer to Setting an Image Cell.

Using Code

Set the BackgroundImage property.
Set the backcolor of the default style.

Example

This example code sets the background image of the sheet.

C#	Copy Code
private void Form1_Load(object sender, System.EventArgs e) { //Specify background images. fpSpread1.BackgroundImage = Image.FromFile("D:\\images\\butterfly.gif"); //Set "Transparent" to the default background color of the sheet. fpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.Transparent; }

Copy Code

private void Form1_Load(object sender, System.EventArgs e)
{
   //Specify background images.
   fpSpread1.BackgroundImage = Image.FromFile("D:\\images\\butterfly.gif");
   //Set "Transparent" to the default background color of the sheet.
   fpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.Transparent;
}

VB	Copy Code
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Specify background images. FpSpread1.BackgroundImage = Image.FromFile("D:\images\butterfly.gif") 'Set "Transparent" to the default background color of the sheet. FpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.Transparent End Sub

Copy Code

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
   'Specify background images.
   FpSpread1.BackgroundImage = Image.FromFile("D:\images\butterfly.gif")
   'Set "Transparent" to the default background color of the sheet.
   FpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.Transparent
End Sub