Set Zoom Magnification of Excel Sheet

Set  Zoom Magnification of Excel Sheet

In this section, you will learn how to set the zoom magnification of a Excel workbook's sheet.

Zoom magnification is expressed as fraction. For example if you want to set the magnification to 75%, you need to implement 3 for the numerator and 4 for the denominator.

You can set the zoom magnification of a sheet as follows :

sheet1.setZoom(3,4);   // 75% magnification

The complete example is given below :

EXAMPLE

In the below code, an Excel(.xlsx) workbook's sheet's magnification is set to 75%.

import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelMagnification {
public static void main(String[] args) throws IOException {
Workbook wb = new XSSFWorkbook();
CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");

// SETTING ZOOM MAGNIFIACTION
sheet.setZoom(3, 4);
// Create a row and put some cells in it. Rows are 0 based.
Row row = sheet.createRow((short) 0);
// Create a cell and put a value in it.
Cell cell = row.createCell(0);
cell.setCellValue(1);

// Or do it on one line.
row.createCell(1).setCellValue(1.2);
row
.createCell(2)
.setCellValue(
createHelper
.createRichTextString("This Sheet's Zoom magnification is set to 75%"));
row.createCell(3).setCellValue(true);

// Write the output to a file

FileOutputStream fileOut = new FileOutputStream("xlsx/workbook2.xlsx");
wb.write(fileOut);
fileOut.close();
}
}

OUTPUT

The content of the workbook sheet is given below whose magnification is set to 75% :

Download Source Code