Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

expand the column out line

In this program we are going to create a sheet create out line for rows and columns. Finally we expand the column outline.

Ads

expand the column out line

     

In this program we are going to create a sheet create out line for rows and columns. Finally we expand the column outline. 

Code description 
The package we need to import is java.io.*,java.util.* ,org.apache.poi.hssf.usermodel.HSSFSheet, and org.apache.poi.hssf.usermodel. HSSFWorkbook.
The method used in this example shift row
grouprow
( startIndex, endIndex):
This is used to create outline for rows startIndex and endIndex shows the starting point and end points for the outline.

groupColumn(startIndex, endIndex):
This is used to create outline for column.

setColumnGroupCollapsed((short)value ,true):
This method is used to collapse the column with it value.

You can create the out line for both rows and columns. The out line is shown in output between + and - linked with state line .Then at last we expand the out line.
 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 contentType="application/vnd.ms-excel" %>
<%page import="java.io.*" %>
<%page import="java.util.*" %>
<%
try{
  HSSFWorkbook hwb = new HSSFWorkbook();
  HSSFSheet sheet = hwb.createSheet("new sheet");
  sheet.groupRow410 );
  sheet.groupRow516);
  sheet.groupRow1315 );
  sheet.groupColumn( (short)4(short));
  sheet.groupColumn( (short)5(short)14 );
  sheet.groupColumn( (short)14(short)14 );
    sheet.setColumnGroupCollapsed( (short)4true );
 FileOutputStream fileOut = new FileOutputStream
(
"c://excel//expandColumnOutLine.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.

Advertisements

Share on Google+Share on Google+

expand the column out line

Posted on: February 25, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: expand the column out line  

Post your Comment


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

Ads

 

Ads