Example usage for org.apache.poi.hssf.usermodel HSSFSheet setZoom

Introduction

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

Prototype

public void setZoom(int numerator, int denominator) 

Source Link

Document

Sets the zoom magnification for the sheet.

Usage

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForBatchXlsView.java

License:Open Source License

@Override
protected final String addContent(final Map<String, Object> model, final HSSFWorkbook workbook,
        final Locale locale) {
    HSSFSheet sheet = workbook.createSheet(
            translationService.translate("qualityControls.qualityControlForBatch.report.title", locale));
    sheet.setZoom(4, 3);
    addOrderHeader(sheet, locale);//ww  w  .  j a  v a  2  s. co  m
    addOrderSeries(model, sheet);
    return translationService.translate("qualityControls.qualityControlForBatch.report.fileName", locale);
}

---

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForOperationXlsView.java

License:Open Source License

@Override
protected final String addContent(final Map<String, Object> model, final HSSFWorkbook workbook,
        final Locale locale) {
    HSSFSheet sheet = workbook.createSheet(
            translationService.translate("qualityControls.qualityControlForOperation.report.title", locale));
    sheet.setZoom(4, 3);
    addOrderHeader(sheet, locale);/*  w w  w  . ja  v a2  s  . c om*/
    addOrderSeries(model, sheet, locale);
    return translationService.translate("qualityControls.qualityControlForOperation.report.fileName", locale);
}

---

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForOrderXlsView.java

License:Open Source License

@Override
protected final String addContent(final Map<String, Object> model, final HSSFWorkbook workbook,
        final Locale locale) {
    HSSFSheet sheet = workbook.createSheet(
            translationService.translate("qualityControls.qualityControlForOrder.report.title", locale));
    sheet.setZoom(4, 3);
    addOrderHeader(sheet, locale);/*from w ww  . ja  v  a 2  s . c om*/
    addOrderSeries(model, sheet, locale);
    return translationService.translate("qualityControls.qualityControlForOrder.report.fileName", locale);
}

---

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForUnitXlsView.java

License:Open Source License

@Override
protected final String addContent(final Map<String, Object> model, final HSSFWorkbook workbook,
        final Locale locale) {
    HSSFSheet sheet = workbook.createSheet(
            translationService.translate("qualityControls.qualityControlForUnit.report.title", locale));
    sheet.setZoom(4, 3);
    addOrderHeader(sheet, locale);//ww  w. j a  va2  s.c  o  m
    addOrderSeries(model, sheet);
    return translationService.translate("qualityControls.qualityControlForUnit.report.fileName", locale);
}

---

From source file:com.qcadoo.report.api.xls.XlsDocumentService.java

License:Open Source License

@Override
public final void generateDocument(final Entity entity, final Locale locale, final Rectangle pageSize)
        throws IOException {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet(getReportTitle(locale));
    addHeader(sheet, locale, entity);/* w w w.  j a va2  s . co  m*/
    addSeries(sheet, entity);
    sheet.setZoom(4, 3);
    FileOutputStream outputStream = null;
    try {
        outputStream = new FileOutputStream(fileService.createReportFile(
                (String) entity.getField("fileName") + "." + ReportService.ReportType.XLS.getExtension()));
        workbook.write(outputStream);
    } catch (IOException e) {
        LOG.error("Problem with generating document - " + e.getMessage());
        if (outputStream != null) {
            outputStream.close();
        }
        throw e;
    }
    outputStream.close();
}

---

From source file:de.maklerpoint.office.Schnittstellen.Excel.ExportExcelXLS.java

License:Open Source License

/**
 * //from   w  w  w. j  a  v a2  s.  c o m
 * @throws FileNotFoundException
 * @throws IOException
 */

public void write() throws FileNotFoundException, IOException {
    FileOutputStream out = new FileOutputStream(new File(filename));
    HSSFWorkbook wb;

    wb = new HSSFWorkbook();

    Map<String, HSSFCellStyle> styles = createStyles(wb);
    HSSFSheet sheet = wb.createSheet(sheetName);

    //turn off gridlines
    sheet.setDisplayGridlines(false);
    sheet.setPrintGridlines(false);
    sheet.setFitToPage(true);
    sheet.setHorizontallyCenter(true);
    HSSFPrintSetup printSetup = sheet.getPrintSetup();
    printSetup.setLandscape(true);

    sheet.setAutobreaks(true);
    printSetup.setFitHeight((short) 1);
    printSetup.setFitWidth((short) 1);

    HSSFRow headerRow = sheet.createRow(0);
    headerRow.setHeightInPoints(12.75f);

    int[][] width = new int[titles.length][titles.length];

    for (int i = 0; i < titles.length; i++) {
        HSSFCell cell = headerRow.createCell(i);
        cell.setCellValue(titles[i]);
        cell.setCellStyle(styles.get("header"));

        width[i][0] = titles[i].length();
    }

    HSSFRow row;
    HSSFCell cell;
    int rownum = 1;

    for (int i = 0; i < data.length; i++, rownum++) {
        row = sheet.createRow(rownum);
        if (data[i] == null)
            continue;

        for (int j = 0; j < data[i].length; j++) {
            cell = row.createCell(j);
            if (data[i][j] == null)
                data[i][j] = "";

            cell.setCellValue(data[i][j].toString());

            if (data[i][j].toString().length() > width[j][0])
                width[j][0] = data[i][j].toString().length();
        }
    }

    for (int i = 0; i < titles.length; i++) {
        int widthShort = (256 * (width[i][0] + 3));

        sheet.setColumnWidth(i, widthShort);
    }

    int position = (titles.length / 2) - 1;

    row = sheet.createRow(rownum + 3);
    cell = row.createCell(position);

    if (footName == null) {
        SimpleDateFormat df = new SimpleDateFormat("dd.MM.yyyy HH:mm");
        cell.setCellValue("Export MaklerPoint vom " + df.format(new Date(System.currentTimeMillis()))
                + " - www.maklerpoint.de");
    } else {
        cell.setCellValue(footName);
    }

    sheet.setZoom(3, 4);

    wb.write(out);
    out.close();
}

---

From source file:poi.hssf.usermodel.examples.ZoomSheet.java

License:Apache License

public static void main(String[] args) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");
    sheet1.setZoom(3, 4); // 75 percent magnification
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);//from   w  w w .java  2s .  c  o  m
    fileOut.close();
}

---