Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Tutorials Poi Set Zoom Magnification of Excel Sheet

Related Tutorials


 
 

Share on Google+Share on Google+

Set Zoom Magnification of Excel Sheet

Advertisement
In this section, you will learn how to set the zoom magnification of a Excel workbook's 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% :

A       
B         C D          
1 1.2 This is a string TRUE

Download Source Code

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: August 10, 2011

Related Tutorials

Discuss: Set Zoom Magnification of Excel Sheet  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com