<%@ 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.groupRow( 4, 10 ); sheet.groupRow( 5, 16); sheet.groupRow( 13, 15 ); sheet.groupColumn( (short)4, (short)6 ); sheet.groupColumn( (short)5, (short)14 ); sheet.groupColumn( (short)14, (short)14 ); sheet.setColumnGroupCollapsed( (short)4, true ); FileOutputStream fileOut = new FileOutputStream("c://excel//expandColumnOutLine.xls"); hwb.write(fileOut); fileOut.close(); out.println("Your excel file has been generated"); } catch ( Exception ex ) { } %>