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;
}
