Example usage for org.apache.poi.hssf.model InternalSheet TopMargin

Introduction

In this page you can find the example usage for org.apache.poi.hssf.model InternalSheet TopMargin.

Prototype

short TopMargin

To view the source code for org.apache.poi.hssf.model InternalSheet TopMargin.

Click Source Link

Usage

From source file:ro.nextreports.engine.exporter.XlsExporter.java

License:Apache License

protected void newPage() {
    addRegions(xlsSheet, regions, wb);/*w ww.  j  av a 2  s .  co  m*/
    if (hasTemplate()) {
        xlsSheet = wb.getSheetAt(bean.getReportLayout().getTemplateSheet() - 1);
    } else {
        // for a group name inside sheet name when we create a page we do not have the group name yet
        // so we will have to set the name of the previous sheet (see also finishExport where we set the name of the last sheet(s)
        String sheetName = replaceSheetNameParam(bean.getReportLayout().getSheetNames());
        if ((sheetName == null) || sheetName.isEmpty()) {
            sheetName = String.valueOf(page);
        }
        if (sheetNameContainsGroup(bean.getReportLayout().getSheetNames()) && (page > 1)) {
            // current group is for previous sheet page         
            xlsSheet = wb.createSheet(String.valueOf(page));
            wb.setSheetName(page - 2, sheetName);
        } else {
            xlsSheet = wb.createSheet(sheetName);
        }
    }
    xlsSheet.setMargin(InternalSheet.LeftMargin, getInches(bean.getReportLayout().getPagePadding().getLeft()));
    xlsSheet.setMargin(InternalSheet.RightMargin,
            getInches(bean.getReportLayout().getPagePadding().getRight()));
    xlsSheet.setMargin(InternalSheet.TopMargin, getInches(bean.getReportLayout().getPagePadding().getTop()));
    xlsSheet.setMargin(InternalSheet.BottomMargin,
            getInches(bean.getReportLayout().getPagePadding().getBottom()));

    if (bean.getReportLayout().getOrientation() == LANDSCAPE) {
        xlsSheet.getPrintSetup().setLandscape(true);
    }

    setPaperSize();

    patriarch = xlsSheet.createDrawingPatriarch();
    buildHeader();
    buildFooter();
    page++;
    // first page header is written by ResultExporter
    if (bean.getReportLayout().isHeaderOnEveryPage() && (page > 2)) {
        try {
            printHeaderBand();
        } catch (QueryException e) {
            e.printStackTrace();
        }
    }
}

---