Example usage for org.apache.poi.hssf.util HSSFRegionUtil setBorderRight

Introduction

In this page you can find the example usage for org.apache.poi.hssf.util HSSFRegionUtil setBorderRight.

Prototype

public static void setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) 

Source Link

Document

Sets the borderRight attribute of the HSSFRegionUtil object

Usage

From source file:domain.Excel.java

public void bordes(String rango, short borde) {

        HSSFRegionUtil.setBorderTop(borde, CellRangeAddress.valueOf(rango), (HSSFSheet) sheet, wb);
        HSSFRegionUtil.setBorderLeft(borde, CellRangeAddress.valueOf(rango), (HSSFSheet) sheet, wb);
        HSSFRegionUtil.setBorderRight(borde, CellRangeAddress.valueOf(rango), (HSSFSheet) sheet, wb);
        HSSFRegionUtil.setBorderBottom(borde, CellRangeAddress.valueOf(rango), (HSSFSheet) sheet, wb);
    }//  w  ww .  ja v  a  2s  .c om

---

From source file:org.sigmah.server.endpoint.export.sigmah.spreadsheet.ExcelUtils.java

License:Open Source License

public CellRangeAddress getBorderedRegion(CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook wb) {
    final short solid = CellStyle.BORDER_THIN;
    HSSFRegionUtil.setBorderBottom(solid, region, sheet, wb);
    HSSFRegionUtil.setBorderTop(solid, region, sheet, wb);
    HSSFRegionUtil.setBorderLeft(solid, region, sheet, wb);
    HSSFRegionUtil.setBorderRight(solid, region, sheet, wb);
    HSSFRegionUtil.setBottomBorderColor(IndexedColors.BLACK.getIndex(), region, sheet, wb);
    HSSFRegionUtil.setTopBorderColor(IndexedColors.BLACK.getIndex(), region, sheet, wb);
    HSSFRegionUtil.setLeftBorderColor(IndexedColors.BLACK.getIndex(), region, sheet, wb);
    HSSFRegionUtil.setRightBorderColor(IndexedColors.BLACK.getIndex(), region, sheet, wb);
    return region;
}

---

From source file:ro.nextreports.engine.exporter.XlsExporter.java

License:Apache License

private void addRegions(HSSFSheet xlsSheet, List<XlsRegion> regions, HSSFWorkbook wb) {
    for (int r = 0, size = regions.size(); r < size; r++) {
        XlsRegion xlsRegion = regions.get(r);
        CellRangeAddress region = xlsRegion.getCellRangeAddress();
        Border border = xlsRegion.getBorder();
        xlsSheet.addMergedRegion(region);

        if (border != null) {
            short xlsBottomBorder = getXlsBorderValue(border.getBottom());
            if (xlsBottomBorder > 0) {
                HSSFRegionUtil.setBorderBottom(xlsBottomBorder, region, xlsSheet, wb);
                HSSFRegionUtil.setBottomBorderColor(ExcelColorSupport.getNearestColor(border.getBottomColor()),
                        region, xlsSheet, wb);
            }/*from  w  w w  .jav  a  2 s  . c  o m*/
            short xlsTopBorder = getXlsBorderValue(border.getTop());
            if (xlsTopBorder > 0) {
                HSSFRegionUtil.setBorderTop(xlsTopBorder, region, xlsSheet, wb);
                HSSFRegionUtil.setTopBorderColor(ExcelColorSupport.getNearestColor(border.getTopColor()),
                        region, xlsSheet, wb);
            }
            short xlsLeftBorder = getXlsBorderValue(border.getLeft());
            if (xlsLeftBorder > 0) {
                HSSFRegionUtil.setBorderLeft(xlsLeftBorder, region, xlsSheet, wb);
                HSSFRegionUtil.setLeftBorderColor(ExcelColorSupport.getNearestColor(border.getLeftColor()),
                        region, xlsSheet, wb);
            }
            short xlsRightBorder = getXlsBorderValue(border.getRight());
            if (xlsRightBorder > 0) {
                HSSFRegionUtil.setBorderRight(xlsRightBorder, region, xlsSheet, wb);
                HSSFRegionUtil.setRightBorderColor(ExcelColorSupport.getNearestColor(border.getRightColor()),
                        region, xlsSheet, wb);
            }
        }

    }
    regions.clear();
}

---