Set Background Picture of a Worksheet

To apply a background image to a spreadsheet:

1. Create a workbook and access the sheet you want to apply a background image to.
2. Apply the background image.
3. Save the workbook.

The code samples that follow show how to do this first with VSTO, using either C# or Visual Basic, and then with Aspose.Cells for .NET, again using either C# or Visual Basic.

The code examples in this article create a worksheet with a repeating background image, like the one in the screentshot below.

!

A background has been set for the worksheet.

VSTO

~~~~~

//Instantiate the Application object.
Excel.Application ExcelApp = Application;
//Add a Workbook.
Excel.Workbook objBook = ExcelApp.Workbooks.Add(System.Reflection.Missing.Value);
//Get the First sheet.
Excel.Worksheet objSheet = (Excel.Worksheet)objBook.Sheets["Sheet1"];

        //Set a background picture for the sheet.
        objSheet.SetBackgroundPicture("pic.jpeg");

        //Save the excel file.
        objBook.SaveCopyAs("BackgroundPicBook.xls");
        //Quit the Application.
        ExcelApp.Quit();

**Aspose.Cells**

//Instantiate a new Workbook.
Workbook workbook = new Workbook();
//Get the first worksheet.
Worksheet sheet = workbook.Worksheets[0];

        //Define a string variable to store the image path.
        string ImageUrl = "pic.jpeg";
        //Get the picture into the streams.
        FileStream fs = File.OpenRead(ImageUrl);
        //Define a byte array.
        byte[] imageData = new Byte[fs.Length];
        //Obtain the picture into the array of bytes from streams.
        fs.Read(imageData, 0, imageData.Length);
        //Close the stream.
        fs.Close();

        //Set the background image for the sheet.
        sheet.SetBackground(imageData);

        //Save the excel file.
        workbook.Save("BackgroundPicBook.xls");

~~~~~~

Download

• Sample Code