Example usage for org.apache.poi.hssf.record ExtendedFormatRecord setTopBorderPaletteIdx

Introduction

In this page you can find the example usage for org.apache.poi.hssf.record ExtendedFormatRecord setTopBorderPaletteIdx.

Prototype

public void setTopBorderPaletteIdx(short border) 

Source Link

Document

set the palette index for the top border

Usage

From source file:com.haulmont.yarg.formatters.impl.xls.HSSFWorkbookHelper.java

License:Apache License

public static ExtendedFormatRecord createExtendedFormat() {
    // CAUTION copied from org.apache.poi.hssf.model.InternalWorkbook#createExtendedFormat

    ExtendedFormatRecord retval = new ExtendedFormatRecord();

    retval.setFontIndex((short) 0);
    retval.setFormatIndex((short) 0x0);
    retval.setCellOptions((short) 0x1);
    retval.setAlignmentOptions((short) 0x20);
    retval.setIndentionOptions((short) 0);
    retval.setBorderOptions((short) 0);
    retval.setPaletteOptions((short) 0);
    retval.setAdtlPaletteOptions((short) 0);
    retval.setFillPaletteOptions((short) 0x20c0);
    retval.setTopBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setBottomBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setLeftBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setRightBorderPaletteIdx(HSSFColor.BLACK.index);
    return retval;
}

---