/// <summary> /// Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left /// </summary> /// <param name="border">The new border</param> /// <param name="region">The region that should have the border</param> /// <param name="sheet">The sheet that the region is on.</param> public static void SetBorderLeft(int border, CellRangeAddress region, ISheet sheet) { int rowStart = region.FirstRow; int rowEnd = region.LastRow; int column = region.FirstColumn; CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_LEFT, border); for (int i = rowStart; i <= rowEnd; i++) { cps.SetProperty(CellUtil.GetRow(i, sheet), column); } }
/// <summary> /// Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top /// </summary> /// <param name="color">The color of the border</param> /// <param name="region">The region that should have the border</param> /// <param name="sheet">The sheet that the region is on.</param> public static void SetTopBorderColor(int color, CellRangeAddress region, ISheet sheet) { int colStart = region.FirstColumn; int colEnd = region.LastColumn; int rowIndex = region.FirstRow; CellPropertySetter cps = new CellPropertySetter(CellUtil.TOP_BORDER_COLOR, color); IRow row = CellUtil.GetRow(rowIndex, sheet); for (int i = colStart; i <= colEnd; i++) { cps.SetProperty(row, i); } }
/// <summary> /// Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right /// </summary> /// <param name="color">The color of the border</param> /// <param name="region">The region that should have the border</param> /// <param name="sheet">The sheet that the region is on.</param> public static void SetRightBorderColor(int color, CellRangeAddress region, ISheet sheet) { int rowStart = region.FirstRow; int rowEnd = region.LastRow; int column = region.LastColumn; CellPropertySetter cps = new CellPropertySetter(CellUtil.RIGHT_BORDER_COLOR, color); for (int i = rowStart; i <= rowEnd; i++) { cps.SetProperty(CellUtil.GetRow(i, sheet), column); } }
/** * Sets the borderBottom attribute of the RegionUtil object * * @param border The new border * @param region The region that should have the border * @param workbook The workbook that the region is on. * @param sheet The sheet that the region is on. */ public static void SetBorderTop(int border, CellRangeAddress region, ISheet sheet, IWorkbook workbook) { int colStart = region.FirstColumn; int colEnd = region.LastColumn; int rowIndex = region.FirstRow; CellPropertySetter cps = new CellPropertySetter(workbook, CellUtil.BORDER_TOP, border); IRow row = CellUtil.GetRow(rowIndex, sheet); for (int i = colStart; i <= colEnd; i++) { cps.SetProperty(row, i); } }
public void SetProperty(IRow row, int column) { ICell cell = CellUtil.GetCell(row, column); CellUtil.SetCellStyleProperty(cell, _propertyName, _propertyValue); }