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

Introduction

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

Prototype

short BottomMargin

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

Click Source Link

Usage

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

License:Apache License

protected void newPage() {
    addRegions(xlsSheet, regions, wb);//  w  w  w .  j  av  a  2s . c o 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();
        }
    }
}

---