jsp導(dǎo)出excel有很多種方法，在此介紹本人認為簡單的一種，
前提：能在jsp頁面取到要導(dǎo)出的內(nèi)容，即 request能得到導(dǎo)出的數(shù)據(jù)，然后代碼如下
<%
@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.util.*,
org.apache.poi.hssf.usermodel.HSSFWorkbook,
org.apache.poi.hssf.usermodel.HSSFSheet,
org.apache.poi.hssf.usermodel.HSSFRow,
org.apache.poi.hssf.usermodel.HSSFCell,
java.text.DecimalFormat"%>
<%
response.reset();
response.setContentType("application/msexcel");
response.setHeader("Content-disposition","inline;filename=untitled.xls");//定義文件名
DecimalFormat f = new DecimalFormat("#,##0.00");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
String[] taxpayerid = request.getParameterValues("taxpayerid");
String[] taxpayername = request.getParameterValues("taxpayername");
String[] tax = request.getParameterValues("tax");
String[] taxreduce = request.getParameterValues("taxreduce");
String[] deratereasonname = request.getParameterValues("deratereasonname");
String[] orgdeptname = request.getParameterValues("orgdeptname");
String[] operatortime = request.getParameterValues("operatortime");
String[] declaredate = request.getParameterValues("declaredate");
String[] taxtermbegin = request.getParameterValues("taxtermbegin");
String[] taxtermend = request.getParameterValues("taxtermend");
//以下以寫表頭
//表頭為第一行
HSSFRow row = sheet.createRow((short) 0);
//定義10列
HSSFCell cell1 = row.createCell((short) 0);
HSSFCell cell2 = row.createCell((short) 1);
HSSFCell cell3 = row.createCell((short) 2);
HSSFCell cell4 = row.createCell((short) 3);
HSSFCell cell5 = row.createCell((short) 4);
HSSFCell cell6 = row.createCell((short) 5);
HSSFCell cell7 = row.createCell((short) 6);
HSSFCell cell8 = row.createCell((short) 7);
HSSFCell cell9 = row.createCell((short) 8);
HSSFCell cell10 = row.createCell((short) 9);
cell1.setEncoding((short) 1);
cell1.setCellType(1);
cell2.setEncoding((short) 1);
cell2.setCellType(1);
cell3.setEncoding((short) 1);
cell3.setCellType(1);
cell4.setEncoding((short) 1);
cell4.setCellType(1);
cell5.setEncoding((short) 1);
cell5.setCellType(0);
cell6.setEncoding((short) 1);
cell6.setCellType(1);
cell7.setEncoding((short) 1);
cell7.setCellType(1);
cell8.setEncoding((short) 1);
cell8.setCellType(1);
cell9.setEncoding((short) 1);
cell9.setCellType(1);
cell10.setEncoding((short) 1);
cell10.setCellType(1);
//定義表頭的內(nèi)容
cell1.setCellValue("納稅人管理碼");
cell2.setCellValue("納稅人名稱");
cell3.setCellValue("稅種");
cell4.setCellValue("減免金額");
cell5.setCellValue("減免原因");
cell6.setCellValue("征收單位");
cell7.setCellValue("操作日期");
cell8.setCellValue("申報日期");
cell9.setCellValue("所屬期起");
cell10.setCellValue("所屬期止");
for(int i= 0; i < taxpayerid.length; i++){
//定義數(shù)據(jù)從第二行開始
row = sheet.createRow((short) i+1);
cell1 = row.createCell((short) 0);
cell2 = row.createCell((short) 1);
cell3 = row.createCell((short) 2);
cell4 = row.createCell((short) 3);
cell5 = row.createCell((short) 4);
cell6 = row.createCell((short) 5);
cell7 = row.createCell((short) 6);
cell8 = row.createCell((short) 7);
cell9 = row.createCell((short) 8);
cell10 = row.createCell((short) 9);
cell1.setEncoding((short) 1);
cell1.setCellType(1);
cell2.setEncoding((short) 1);
cell2.setCellType(1);
cell3.setEncoding((short) 1);
cell3.setCellType(1);
cell4.setEncoding((short) 1);
cell4.setCellType(1);
cell5.setEncoding((short) 1);
cell5.setCellType(0);
cell6.setEncoding((short) 1);
cell6.setCellType(1);
cell7.setEncoding((short) 1);
cell7.setCellType(1);
cell8.setEncoding((short) 1);
cell8.setCellType(1);
cell9.setEncoding((short) 1);
cell9.setCellType(1);
cell10.setEncoding((short) 1);
cell10.setCellType(1);
//填充內(nèi)容
cell1.setCellValue(taxpayerid[i]);
cell2.setCellValue(taxpayername[i]);
cell3.setCellValue(tax[i]);
cell4.setCellValue(f.parse(taxreduce[i].trim()).doubleValue());
cell5.setCellValue(deratereasonname[i]);
cell6.setCellValue(orgdeptname[i]);
cell7.setCellValue(operatortime[i].substring(0,16));
cell8.setCellValue(declaredate[i].substring(0,16));
cell9.setCellValue(taxtermbegin[i].substring(0,16));
cell10.setCellValue(taxtermend[i].substring(0,16));
}
wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>代碼比較簡單，首先把取得到的數(shù)據(jù)定義為一系列數(shù)組，然后定義表頭，然后把取得的數(shù)據(jù)做為excel數(shù)據(jù)對應(yīng)的放入，對poi有何疑問請參考
http://java2.5341.com/3.html