When filling the cells with Background with color gray, we need to set the pattern to Solid. But Solid is not effecting the cells with solid pattern.
sheet.Cells[5, 0].Style.BackgroundColor = System.Drawing.Color.Gray;
sheet.Cells[5, 0].Style.Pattern = BackgroundType.Solid;
Kindly help !