Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFPrintSetup

56
57
58
59
60
61
62
63
64
65
66
67
68
69
   
    // PageSettingBlock in this file contains PLS (sid=x004D) record
    // followed by ContinueRecord (sid=x003C) 
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("ex46548-23133.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFPrintSetup ps = sheet.getPrintSetup();
   
    try {
      ps.getCopies();
    } catch (NullPointerException e) {
      e.printStackTrace();
      throw new AssertionFailedError("Identified bug 46548: PageSettingBlock missing PrintSetupRecord record");
    }
  }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
        wb.setPrintArea(0, 0, colCount, 0, rowCount);
        HSSFFooter footer = sheet.getFooter();
        footer.setCenter("Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages());
        // Fit Sheet to 1 page wide but very long
        sheet.setAutobreaks(true);
        HSSFPrintSetup ps = sheet.getPrintSetup();
        ps.setFitWidth((short)1);
        ps.setFitHeight((short)9999);
        sheet.setGridsPrinted(true);
        sheet.setHorizontallyCenter(true);
        ps.setPaperSize(HSSFPrintSetup.LETTER_PAPERSIZE);
        if(colCount > 5){ps.setLandscape(true);}
        if(colCount > 10){ps.setPaperSize(HSSFPrintSetup.LEGAL_PAPERSIZE);}
        if(colCount > 14){ps.setPaperSize(HSSFPrintSetup.EXECUTIVE_PAPERSIZE);}
        // Set Margins
        ps.setHeaderMargin((double) .35);
        ps.setFooterMargin((double) .35);
        sheet.setMargin(HSSFSheet.TopMargin, (double) .50);
        sheet.setMargin(HSSFSheet.BottomMargin, (double) .50);
        sheet.setMargin(HSSFSheet.LeftMargin, (double) .50);
        sheet.setMargin(HSSFSheet.RightMargin, (double) .50);
       
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    // PageSettingBlock in this file contains PLS (sid=x004D) record
    // followed by ContinueRecord (sid=x003C)
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("ex46548-23133.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFPrintSetup ps = sheet.getPrintSetup();

    try {
      ps.getCopies();
    } catch (NullPointerException e) {
      e.printStackTrace();
      throw new AssertionFailedError("Identified bug 46548: PageSettingBlock missing PrintSetupRecord record");
    }
  }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
   
    // PageSettingBlock in this file contains PLS (sid=x004D) record
    // followed by ContinueRecord (sid=x003C) 
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("ex46548-23133.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFPrintSetup ps = sheet.getPrintSetup();
   
    try {
      ps.getCopies();
    } catch (NullPointerException e) {
      e.printStackTrace();
      throw new AssertionFailedError("Identified bug 46548: PageSettingBlock missing PrintSetupRecord record");
    }
  }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    // PageSettingBlock in this file contains PLS (sid=x004D) record
    // followed by ContinueRecord (sid=x003C)
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("ex46548-23133.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFPrintSetup ps = sheet.getPrintSetup();

    try {
      ps.getCopies();
    } catch (NullPointerException e) {
      e.printStackTrace();
      throw new AssertionFailedError("Identified bug 46548: PageSettingBlock missing PrintSetupRecord record");
    }
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
    s.setFitToPage(sheet.isFitToPage());
    s.setHorizontallyCenter(sheet.isHorizontallyCenter());
    s.setAutobreaks(true);

    // Print Config
    HSSFPrintSetup printSetup = s.getPrintSetup();
    printSetup.setLandscape(sheet.isLandscape());
    printSetup.setFitHeight((short) 1);
    printSetup.setFitWidth((short) 1);

    // Rows
    int rowNum = 0;

    for (Row row : sheet.getRows()) {
View Full Code Here
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
        /**
         * Print setup
         */
        xlsSheet.autoSizeColumn((short) 0);

        HSSFPrintSetup printSetup = xlsSheet.getPrintSetup();

        printSetup.setHResolution(sheetResolution);
        printSetup.setVResolution(sheetResolution);
        printSetup.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE);
        printSetup.setLandscape(orientation != null && orientation.equalsIgnoreCase("landscape"));
        workbook.setPrintArea(workbook.getSheetIndex(xlsSheet), printAreaColumnStart, printAreaColumnEnd, printAreaRowStart, printAreaRowEnd);
        xlsSheet.setAutobreaks(true);
        printSetup.setFitWidth((short) 1);
        printSetup.setFitHeight((short) 0);
        printSetup.setHeaderMargin(0.1d);

        for (int i = 0; i < modelSheet.getRowBreaks().length; i++) {
            xlsSheet.setRowBreak(modelSheet.getRowBreaks()[i]);
        }

View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
    // PageSettingBlock in this file contains PLS (sid=x004D) record
    // followed by ContinueRecord (sid=x003C)
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("ex46548-23133.xls");
    HSSFSheet sheet = wb.getSheetAt(0);
    HSSFPrintSetup ps = sheet.getPrintSetup();

    try {
      ps.getCopies();
    } catch (NullPointerException e) {
      e.printStackTrace();
      throw new AssertionFailedError("Identified bug 46548: PageSettingBlock missing PrintSetupRecord record");
    }
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
    s.setFitToPage(sheet.isFitToPage());
    s.setHorizontallyCenter(sheet.isHorizontallyCenter());
    s.setAutobreaks(true);

    // Print Config
    HSSFPrintSetup printSetup = s.getPrintSetup();
    printSetup.setLandscape(sheet.isLandscape());
    printSetup.setFitHeight((short) 1);
    printSetup.setFitWidth((short) 1);

    // Rows
    int rowNum = 0;

    for (Row row : sheet.getRows()) {
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
    s.setFitToPage(sheet.isFitToPage());
    s.setHorizontallyCenter(sheet.isHorizontallyCenter());
    s.setAutobreaks(true);

    // Print Config
    HSSFPrintSetup printSetup = s.getPrintSetup();
    printSetup.setLandscape(sheet.isLandscape());
    printSetup.setFitHeight((short) 1);
    printSetup.setFitWidth((short) 1);

    // Rows
    int rowNum = 0;

    for (Row row : sheet.getRows()) {
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFPrintSetup

  • br.net.woodstock.rockframework.document.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • org.apache.poi.hssf.record.aggregates.TestPageSettingBlock
  • org.apache.poi.hssf.record.aggregates.TestPageSettingsBlock
  • org.crank.controller.ExcelExportControllerBean
  • org.uguess.birt.report.engine.emitter.xls.XlsRenderer
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.