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

Introduction

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

Prototype

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

Source Link

Document

Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left

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.j  a v a  2s  .  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 w w .  j  a va2s . 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();
}

---