public static ICellStyle SetRegionColor(this ISheet ISheet1, int startRow, int startColumn, int endRow,
int endColumn, HSSFColor color, ICellStyle style)
{
if (style == null)
{
style = ICellStyleManager.CreateStyle(ISheet1.Workbook);
}
style.SetFillColor(color);
return(ISheet1.SetRegionStyle(startRow, startColumn, endRow, endColumn, style));
}
public static ICellStyle CreateFillColor(this IWorkbook workbook, HSSFColor color)
{
ICellStyle style1 = ICellStyleManager.CreateStyle(workbook);
return(style1.SetFillColor(color));
}
public static ICellStyle CreateBackgroundColor(this IWorkbook workbook, HSSFColor foreColor, HSSFColor backColor, FillPattern pattern)
{
ICellStyle style1 = ICellStyleManager.CreateStyle(workbook);
return(style1.SetBackgroundColor(foreColor, backColor, pattern));
}
public static ICellStyle CreateBorder(this IWorkbook hssfworkbook, HSSFColor color)
{
ICellStyle blackBorder = ICellStyleManager.CreateStyle(hssfworkbook);
return(blackBorder.SetBorder(color));
}
