Home Jsp Poi Zoom Out Excel

Zoom Out Excel
Posted on: May 19, 2007 at 12:00 AM

In this program we are going to make a java program through which we can zoom out(+) an excel sheet.

zoom out excel

In this program we are going to make a java program through which we can zoom out(+) an excel sheet. This means you can make an excel sheet larger than their original size .

The package we need to import is java.io.*,java.util.* ,org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.usermodel.HSSFRow, org.apache.poi.usermodel.HSSFCell and org.apache.poi.hssf.usermodel. HSSFWorkbook.

setZoom(int,int):
This method is used to set the zoom ratio of the excel sheet e.g. setZoom(4,3) means zoom the sheet to 125%.

In this example, we are creating the sheet and set the zoom ratio 200%.This means the output of the sheet will be zoomed out 100% of their original size. In other words we can say the size of excel sheet will be expanded by 100%.

The code of the program is given below:


<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%>

<%@ page contentType="application/vnd.ms-excel" %>

<%@ page import="java.io.*" %>

<%@ page import="java.util.*" %>

<%

try{

  HSSFWorkbook hwb = new HSSFWorkbook();

      HSSFSheet sheet = hwb.createSheet("new sheet");

      HSSFRow row = sheet.createRow((short)1);

      HSSFCell cell = row.createCell((short)1);

      cell.setCellValue(111111);  

      sheet.setZoom(6,3);

     FileOutputStream fileOut = new FileOutputStream

    ("c:\\excel\\zoomSheetOut.xls");

     hwb.write(fileOut);

     fileOut.close();

     out.println("Your excel file has been generated");

    

  } catch ( Exception ex ) {

  

  }%>

The output of the program is given below:

Download this example.

Related Tags for Zoom Out Excel:
java, c, excel, apache, import, model, io, size, user, output, word, port, this, cell, package, set, zoom, oo, row, boo, poi, example, work, book, to, expand, exam, mode, sh, words, e, il, can, put, use, im, ce, in, java.io, mod, rm, m, out, sheet, oom, ca, oom, j, pack, age, me, mean, pan, ack, fs, gina, creating, xa, xamp, s, del, ee, gin, at, pac, ratio, origin, k, is, ir, ll, mpl, ea, and, ar, rds, rt, sa, xp, xpand, util, usermode, va, uti, z, s, s, ri, rd, th, av, ati, ap, kb, hssf, org, ple, pl, nd, oome, ode, om, o

«Previous Index Next»