It seems the transparency can not be set on a row by any mean.
Here's what I've tried to make a row transparent:
- Code: Select all
using (var workbook = new Workbook())
{
var worksheet = workbook.Worksheets[0];
CellRange row = worksheet.Rows[0];
// Below are the "color" lines I've tried independently each time
row.Style.Color = Color.Transparent; // Row is filled with the white color
row.Style.Color = Color.FromKnownColor(Color.Transparent); // Row is filled with the white color
row.Style.Color = Color.Empty; // Row is filled with the white color
row.Style.Color = Color.FromArgb(0, Color.White); // Row is filled with the white color
row.Style.Color = Color.FromArgb(0, Color.Transparent); // Row is filled with the white color
row.Style.Color = Color.FromArgb(0, 0, 0, 0); // Row is filled with the white color
workbook.SaveToFile(@"C:\your_path\Test.xlsx");
}
Am I doing it wrong? If so, could you please provide me with a solution for making a row transparent (as per default), please?
Thank you.