[]
        
(Showing Draft Content)

Set Cell Background Image for Cell Range

GcExcel enables you to set the cell background image and its layout for the cell range using BackgroundImage and BackgroundImageLayout properties in IRange interface. You can only export the cell background image to PDF, HTML, and IMG and can only view it in SpreadJS when saved in .sjs format. BackgroundImageLayout enumeration allows you to set the background image layout to Stretch (default), Center, Zoom, or None.

GcExcel only supports and exports the following image formats as the cell background image:

  • PNG

  • JPEG/JPG

  • ICO

  • SVG

  • GIF

Refer to the following example code to add a cell background image in different layouts and export the workbook to a PDF file:

// Create a new workbook.
var workbook = new Workbook();

IWorksheet worksheet = workbook.Worksheets[0];

// Load the image.
byte[] imageBytes = File.ReadAllBytes("Chrome_icon.png");

worksheet.Range["A2:E2"].Value = new string[] { "Stretch", "Center", "Zoom", "None", "Default(Stretch)" };
worksheet.Range["A3:E3"].Value = "Chrome";
worksheet.Range["A3:E3"].RowHeightInPixel = 80;
worksheet.Range["A3:E3"].ColumnWidthInPixel = 100;

// Add cell background image.
worksheet.Range["A3:E3"].BackgroundImage = imageBytes;

// Set image layout.
worksheet.Range["A3"].BackgroundImageLayout = BackgroundImageLayout.Stretch;
worksheet.Range["B3"].BackgroundImageLayout = BackgroundImageLayout.Center;
worksheet.Range["C3"].BackgroundImageLayout = BackgroundImageLayout.Zoom;
worksheet.Range["D3"].BackgroundImageLayout = BackgroundImageLayout.None;

// Set PDF export options.
workbook.ActiveSheet.PageSetup.PrintGridlines = true;
workbook.ActiveSheet.PageSetup.PrintHeadings = true;

// Save to a PDF file.
workbook.Save("CellBackgroundImage.pdf");

image

Limitations

GcExcel does not support saving the background image to Excel; hence, you cannot view it in Excel.