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

Introduction

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

Prototype

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

Source Link

Document

Sets the topBorderColor 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);
            }//from ww  w  .  ja  va2  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();
}

---