public static CellRangeAddress ConvertToCellRangeAddress(Region r) { return new CellRangeAddress(r.RowFrom, r.RowTo, r.ColumnFrom, r.ColumnTo); }
/** * Convert a List of CellRange objects to an array of regions * * @param List of CellRange objects * @return regions */ public static Region[] ConvertCellRangesToRegions(CellRangeAddress[] cellRanges) { int size = cellRanges.Length; if (size < 1) { return new Region[0]; } Region[] result = new Region[size]; for (int i = 0; i != size; i++) { result[i] = ConvertToRegion(cellRanges[i]); } return result; }
public static CellRangeAddress[] ConvertRegionsToCellRanges(Region[] regions) { int size = regions.Length; if (size < 1) { return new CellRangeAddress[0]; } CellRangeAddress[] result = new CellRangeAddress[size]; for (int i = 0; i != size; i++) { result[i] = ConvertToCellRangeAddress(regions[i]); } return result; }
public static void SetBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) { SetBorderLeft(border, toCRA(region), sheet, workbook); }
public static void SetLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) { SetLeftBorderColor(color, toCRA(region), sheet, workbook); }
private static CellRangeAddress toCRA(Region region) { return Region.ConvertToCellRangeAddress(region); }
/// <summary> /// Adds a merged region of cells (hence those cells form one) /// </summary> /// <param name="region">The region (rowfrom/colfrom-rowto/colto) to merge.</param> /// <returns>index of this region</returns> public int AddMergedRegion(Region region) { return sheet.AddMergedRegion(region.RowFrom, region.ColumnFrom, region.RowTo, region.ColumnTo); }
private static CellRange CreateFromRegion(Region r) { return new CellRange(r.RowFrom, r.RowTo, r.ColumnFrom, r.ColumnTo); }
/** * Convert a List of CellRange objects to an array of regions * * @param List of CellRange objects * @return regions */ public static Region[] ConvertCellRangesToRegions(CellRange[] cellRanges) { int size = cellRanges.Length; if (size < 1) { return EMPTY_REGION_ARRAY; } Region[] result = new Region[size]; for (int i = 0; i != size; i++) { result[i] = cellRanges[i].ConvertToRegion(); } return result; }
/** * Convert array of regions to a List of CellRange objects * * @param regions * @return List of CellRange objects */ public static CellRange[] ConvertRegionsToCellRanges(Region[] regions) { CellRange[] result = new CellRange[regions.Length]; for (int i = 0; i < regions.Length; i++) { result[i] = CreateFromRegion(regions[i]); } return result; }