Examples with Workbook org.apache.poi.ss.usermodel.Workbook used on opensource projects

Example 21 with Workbook

use of org.apache.poi.ss.usermodel.Workbook in project poi by apache.

the class FitSheetToOnePage method main.

public static void main(String[] args) throws IOException {
    //or new HSSFWorkbook();
    Workbook wb = new XSSFWorkbook();
    Sheet sheet = wb.createSheet("format sheet");
    PrintSetup ps = sheet.getPrintSetup();
    sheet.setAutobreaks(true);
    ps.setFitHeight((short) 1);
    ps.setFitWidth((short) 1);
    // Create various cells and rows for spreadsheet.
    FileOutputStream fileOut = new FileOutputStream("fitSheetToOnePage.xlsx");
    wb.write(fileOut);
    fileOut.close();
    wb.close();
}

Example 22 with Workbook

use of org.apache.poi.ss.usermodel.Workbook in project poi by apache.

the class WorkingWithFonts method main.

public static void main(String[] args) throws IOException {
    //or new HSSFWorkbook();
    Workbook wb = new XSSFWorkbook();
    Sheet sheet = wb.createSheet("Fonts");
    Font font0 = wb.createFont();
    font0.setColor(IndexedColors.BROWN.getIndex());
    CellStyle style0 = wb.createCellStyle();
    style0.setFont(font0);
    Font font1 = wb.createFont();
    font1.setFontHeightInPoints((short) 14);
    font1.setFontName("Courier New");
    font1.setColor(IndexedColors.RED.getIndex());
    CellStyle style1 = wb.createCellStyle();
    style1.setFont(font1);
    Font font2 = wb.createFont();
    font2.setFontHeightInPoints((short) 16);
    font2.setFontName("Arial");
    font2.setColor(IndexedColors.GREEN.getIndex());
    CellStyle style2 = wb.createCellStyle();
    style2.setFont(font2);
    Font font3 = wb.createFont();
    font3.setFontHeightInPoints((short) 18);
    font3.setFontName("Times New Roman");
    font3.setColor(IndexedColors.LAVENDER.getIndex());
    CellStyle style3 = wb.createCellStyle();
    style3.setFont(font3);
    Font font4 = wb.createFont();
    font4.setFontHeightInPoints((short) 18);
    font4.setFontName("Wingdings");
    font4.setColor(IndexedColors.GOLD.getIndex());
    CellStyle style4 = wb.createCellStyle();
    style4.setFont(font4);
    Font font5 = wb.createFont();
    font5.setFontName("Symbol");
    CellStyle style5 = wb.createCellStyle();
    style5.setFont(font5);
    Cell cell0 = sheet.createRow(0).createCell(1);
    cell0.setCellValue("Default");
    cell0.setCellStyle(style0);
    Cell cell1 = sheet.createRow(1).createCell(1);
    cell1.setCellValue("Courier");
    cell1.setCellStyle(style1);
    Cell cell2 = sheet.createRow(2).createCell(1);
    cell2.setCellValue("Arial");
    cell2.setCellStyle(style2);
    Cell cell3 = sheet.createRow(3).createCell(1);
    cell3.setCellValue("Times New Roman");
    cell3.setCellStyle(style3);
    Cell cell4 = sheet.createRow(4).createCell(1);
    cell4.setCellValue("Wingdings");
    cell4.setCellStyle(style4);
    Cell cell5 = sheet.createRow(5).createCell(1);
    cell5.setCellValue("Symbol");
    cell5.setCellStyle(style5);
    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("xssf-fonts.xlsx");
    wb.write(fileOut);
    fileOut.close();
    wb.close();
}

Example 23 with Workbook

use of org.apache.poi.ss.usermodel.Workbook in project poi by apache.

the class Outlining method collapseExpandRowColumn.

private void collapseExpandRowColumn() throws IOException {
    Workbook wb2 = new XSSFWorkbook();
    Sheet sheet2 = wb2.createSheet("new sheet");
    sheet2.groupRow(5, 14);
    sheet2.groupRow(7, 14);
    sheet2.groupRow(16, 19);
    sheet2.groupColumn((short) 4, (short) 7);
    sheet2.groupColumn((short) 9, (short) 12);
    sheet2.groupColumn((short) 10, (short) 11);
    sheet2.setRowGroupCollapsed(7, true);
    //sheet1.setRowGroupCollapsed(7,false);
    sheet2.setColumnGroupCollapsed((short) 4, true);
    sheet2.setColumnGroupCollapsed((short) 4, false);
    OutputStream fileOut = new FileOutputStream("outlining_collapsed.xlsx");
    try {
        wb2.write(fileOut);
    } finally {
        fileOut.close();
        wb2.close();
    }
}

Example 24 with Workbook

use of org.apache.poi.ss.usermodel.Workbook in project poi by apache.

the class Outlining method groupRowColumn.

private void groupRowColumn() throws IOException {
    Workbook wb = new XSSFWorkbook();
    Sheet sheet1 = wb.createSheet("new sheet");
    sheet1.groupRow(5, 14);
    sheet1.groupRow(7, 14);
    sheet1.groupRow(16, 19);
    sheet1.groupColumn((short) 4, (short) 7);
    sheet1.groupColumn((short) 9, (short) 12);
    sheet1.groupColumn((short) 10, (short) 11);
    OutputStream fileOut = new FileOutputStream("outlining.xlsx");
    try {
        wb.write(fileOut);
    } finally {
        fileOut.close();
        wb.close();
    }
}

Example 25 with Workbook

use of org.apache.poi.ss.usermodel.Workbook in project poi by apache.

the class XSSFPivotTable method getPivotArea.

protected AreaReference getPivotArea() {
    final Workbook wb = getDataSheet().getWorkbook();
    AreaReference pivotArea = getPivotCacheDefinition().getPivotArea(wb);
    return pivotArea;
}