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

Introduction

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

Prototype

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

Source Link

Document

Sets the borderBottom 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  w w  . j ava  2  s . c  o  m*/

---

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 ww  .  j a  v a  2  s.c  om
            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();
}

---