<%@ 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 sheet1 = hwb.createSheet("new sheet"); HSSFSheet sheet2 = hwb.createSheet("second sheet"); HSSFSheet sheet = hwb.createSheet("third sheet"); HSSFSheet sheet4 = hwb.createSheet("fourth sheet"); HSSFSheet sheet5 = hwb.createSheet("third sheet"); HSSFSheet sheet6 = hwb.createSheet("fifth sheet"); sheet.setSelected(true); sheet1.setSelected(false); sheet2.setSelected(false); sheet6.setSelected(false); sheet4.setSelected(false); sheet5.setSelected(false); FileOutputStream fileOut = new FileOutputStream("c:\\excel\\selectingSheet.xls"); hwb.write(fileOut); fileOut.close(); out.println("Your excel file has been generated"); } catch ( Exception ex ) { } %>