Image Transparency

GcExcel supports controlling the transparency of an image by providing Transparency property in IPictureFormat interface. The value of Transparency can vary between 0.0 (opaque) to 1.0 (clear).

Using Code

Refer to the following example code to set the transparency of an image.

//create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();

//use sheet index to get worksheet
IWorksheet worksheet = workbook.Worksheets[0];

//add an image
var picture = worksheet.Shapes.AddPicture("Image.png", 10, 10, 200, 100);

//set image transparency as 60%
picture.PictureFormat.Transparency = 0.6;

//save to an excel file
workbook.Save("imagetransparent.xlsx");

Limitation

SpreadJS does not support image transparency, hence this info would be lost when using json I/O.