Example usage for org.apache.poi.hssf.usermodel HSSFHeader setRight

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFHeader setRight.

Prototype

public final void setRight(String newRight) 

Source Link

Usage

From source file:egovframework.rte.fdl.excel.EgovExcelSXSSFServiceTest.java

License:Apache License

/**
 * [Flow #-4]   ?  :  ? ? ?(Header, Footer)? 
 *///w w  w .  j a v a  2s .  c o m
@Test
public void testModifyDocAttribute() throws Exception {

    try {
        log.debug("testModifyDocAttribute start....");

        StringBuffer sb = new StringBuffer();
        sb.append(fileLocation).append("/").append("testModifyDocAttribute.xls");

        if (EgovFileUtil.isExistsFile(sb.toString())) {
            EgovFileUtil.delete(new File(sb.toString()));

            log.debug("Delete file...." + sb.toString());
        }

        HSSFWorkbook wbTmp = new HSSFWorkbook();
        wbTmp.createSheet();

        //  ? ?
        excelService.createWorkbook(wbTmp, sb.toString());

        //  ? 
        HSSFWorkbook wb = excelService.loadWorkbook(sb.toString());
        log.debug("testModifyCellContents after loadWorkbook....");

        HSSFSheet sheet = wb.createSheet("doc test sheet");

        HSSFRow row = sheet.createRow(1);
        HSSFCell cell = row.createCell(1);
        cell.setCellValue(new HSSFRichTextString("Header/Footer Test"));

        // Header
        HSSFHeader header = sheet.getHeader();
        header.setCenter("Center Header");
        header.setLeft("Left Header");
        header.setRight(HSSFHeader.font("Stencil-Normal", "Italic") + HSSFHeader.fontSize((short) 16)
                + "Right Stencil-Normal Italic font and size 16");

        // Footer
        HSSFFooter footer = sheet.getFooter();
        footer.setCenter(HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12) + "- 1 -");
        log.debug("Style is ... " + HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12)
                + "- 1 -");
        footer.setLeft("Left Footer");
        footer.setRight("Right Footer");

        //  ? 
        FileOutputStream out = new FileOutputStream(sb.toString());
        wb.write(out);
        out.close();

        assertTrue(EgovFileUtil.isExistsFile(sb.toString()));

        //////////////////////////////////////////////////////////////////////////
        // ?
        HSSFWorkbook wbT = excelService.loadWorkbook(sb.toString());
        HSSFSheet sheetT = wbT.getSheet("doc test sheet");

        HSSFHeader headerT = sheetT.getHeader();
        assertEquals("Center Header", headerT.getCenter());
        assertEquals("Left Header", headerT.getLeft());
        assertEquals(HSSFHeader.font("Stencil-Normal", "Italic") + HSSFHeader.fontSize((short) 16)
                + "Right Stencil-Normal Italic font and size 16", headerT.getRight());

        HSSFFooter footerT = sheetT.getFooter();
        assertEquals("Right Footer", footerT.getRight());
        assertEquals("Left Footer", footerT.getLeft());
        assertEquals(HSSFHeader.font("Fixedsys", "Normal") + HSSFHeader.fontSize((short) 12) + "- 1 -",
                footerT.getCenter());

    } catch (Exception e) {
        log.error(e.toString());
        throw new Exception(e);
    } finally {
        log.debug("testModifyDocAttribute end....");
    }
}

---

From source file:org.adempiere.impexp.AbstractExcelExporter.java

License:Open Source License

protected void createHeaderFooter(HSSFSheet sheet) {
    // Sheet Header
    HSSFHeader header = sheet.getHeader();
    header.setRight(HSSFHeader.page() + " / " + HSSFHeader.numPages());
    // Sheet Footer
    HSSFFooter footer = sheet.getFooter();
    footer.setLeft(Adempiere.ADEMPIERE_R);
    footer.setCenter(Env.getHeader(getCtx(), 0));
    Timestamp now = new Timestamp(System.currentTimeMillis());
    footer.setRight(DisplayType.getDateFormat(DisplayType.DateTime, getLanguage()).format(now));
}

---

From source file:org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.Sheet.java

License:Apache License

/**
 * Set text to be printed at the top of every page
 *//*from w  w  w  .  j a  v a  2 s  .c o  m*/
void setHeader(String left, String middle, String right) {
    HSSFHeader header = _sheet.getHeader();
    header.setLeft(left);
    header.setCenter(middle);
    header.setRight(right);
}

---

From source file:org.eclipse.scada.ae.ui.views.export.excel.impl.ExportEventsImpl.java

License:Open Source License

private HSSFSheet createSheet(final List<Event> events, final HSSFWorkbook workbook,
        final List<Field> columns) {
    final HSSFSheet sheet = workbook.createSheet(Messages.ExportImpl_ExcelSheet_Name);

    final HSSFHeader header = sheet.getHeader();
    header.setLeft(Messages.ExportImpl_ExcelSheet_Header);
    header.setRight(HeaderFooter.date() + " " + HeaderFooter.time());//$NON-NLS-1$

    final HSSFFooter footer = sheet.getFooter();
    footer.setLeft(String.format(Messages.ExportImpl_ExcelSheet_Footer_1, events.size()));

    footer.setRight(Messages.ExportImpl_ExcelSheet_Footer_2 + HeaderFooter.page()
            + Messages.ExportImpl_ExcelSheet_Footer_3 + HeaderFooter.numPages());

    makeHeader(columns, sheet);//from w w  w . j a v  a2s.co  m

    final HSSFPrintSetup printSetup = sheet.getPrintSetup();
    printSetup.setLandscape(true);
    printSetup.setFitWidth((short) 1);
    printSetup.setFitHeight((short) 0);
    printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE);

    sheet.setAutoFilter(new CellRangeAddress(0, 0, 0, columns.size() - 1));
    sheet.createFreezePane(0, 1);
    sheet.setFitToPage(true);
    sheet.setAutobreaks(true);

    printSetup.setFooterMargin(0.25);

    sheet.setMargin(Sheet.LeftMargin, 0.25);
    sheet.setMargin(Sheet.RightMargin, 0.25);
    sheet.setMargin(Sheet.TopMargin, 0.25);
    sheet.setMargin(Sheet.BottomMargin, 0.5);

    return sheet;
}

---

From source file:org.openXpertya.print.export.AbstractExcelExporter.java

License:Open Source License

protected void createHeaderFooter(HSSFSheet sheet) {
    // Sheet Header
    HSSFHeader header = sheet.getHeader();
    header.setRight(HSSFHeader.page() + " / " + HSSFHeader.numPages());
    // Sheet Footer
    HSSFFooter footer = sheet.getFooter();
    footer.setLeft(OpenXpertya.OXP_R);/*from   w  ww.j  ava  2  s.  com*/
    footer.setCenter(Env.getHeader(getCtx(), 0));
    Timestamp now = new Timestamp(System.currentTimeMillis());
    footer.setRight(DisplayType.getDateFormat(DisplayType.DateTime, getLanguage()).format(now));
}

---