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

Introduction

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

Prototype

public static void setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet,
        HSSFWorkbook workbook) 

Source Link

Document

Sets the leftBorderColor attribute of the HSSFRegionUtil object

Usage

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);
            }/*w  w  w .  ja  va 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();
}

---