Aspose.Cells.Examples.CSharp.Articles.SetBackgroundPicture.Run C# (CSharp) Method

Run() public static method

public static Run ( ) : void
return void
        public static void Run()
        {
            // ExStart:1
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

            // 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 = dataDir+ "aspose-logo.jpg";

            // 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.BackgroundImage = imageData;

            // Save the Excel file
            workbook.Save(dataDir + "BackImageSheet.out.xlsx");

            // Save the HTML file
            workbook.Save(dataDir + "BackImageSheet1.out.html", SaveFormat.Html);
            // ExEnd:1
        }
    }
SetBackgroundPicture