NPOI 设置边框和单元格背景问题
ordinaryStyle.BorderBottom = BorderStyle.Thin;
ordinaryStyle.BorderLeft = BorderStyle.Thin;
ordinaryStyle.BorderRight = BorderStyle.Thin;
ordinaryStyle.BorderTop = BorderStyle.Thin;
ordinaryStyle.BottomBorderColor = HSSFColor.Black.Index;
ordinaryStyle.LeftBorderColor = HSSFColor.Black.Index;
ordinaryStyle.RightBorderColor = HSSFColor.Black.Index;
ordinaryStyle.TopBorderColor = HSSFColor.Black.Index;
var palette = workbook.GetCustomPalette(); //调色板实例
palette.SetColorAtIndex((short)8, 221, 235, 247);
var backgroundColor = palette.FindColor(221, 235, 247);
ordinaryStyle.FillForegroundColor = backgroundColor.Indexed;
ordinaryStyle.FillPattern = FillPattern.SolidForeground;
ordinaryStyle.FillBackgroundColor = backgroundColor.Indexed;
设置单元格背景后,导致边框也被覆盖了,有办法解决吗
我要达到的效果是黑色边框,其他颜色的单元格背景