poi导出excel文件并提示下载

poi-3.0.1-FINAL-20070705.jar;

poi-3.0-alpha1-20050704.jar;

二、获取List类型数据

三、利用poi生成excel文件

/**

* 生成excel文件

* @param tjxxs 写入excel的List数据

* @param xlsName 文件名称

* @param sheetName 内容标题

* @return int

*/

@SuppressWarnings(\"deprecation\")

public int resultSetToExcel(List tjxxs,String xlsName,String sheetName) throws Exception{

if(tjxxs == null || \"\".equals(tjxxs)){

return 0;

}

HSSFWorkbook workbook = new HSSFWorkbook();

HSSFSheet sheet = workbook.createSheet();

workbook.setSheetName(0,sheetName,HSSFWorkbook.ENCODING_UTF_16);

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

HSSFCell cell;

//写入各个字段的名称

// for(int i=1;i<=4;i++){

cell = row.createCell((short)(0));

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(\"序号\");

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

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(\"工作控制号\");

cell = row.createCell((short)(2));

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(\"单位名称\");

cell = row.createCell((short)(3));

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(\"工作类型\");

int iRow=1;

//写入各条记录，每条记录对应Excel中的一行

for(int i = 0;i < tjxxs.size();i++){

WorkListBean tjxx = tjxxs.get(i);

row= sheet.createRow((short)iRow);

cell = row.createCell((short)0);

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(iRow);

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

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(tjxx.getJybh());

cell = row.createCell((short)2);

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(tjxx.getDwmc());

cell = row.createCell((short)3);

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

cell.setCellValue(tjxx.getTypename());

iRow++;

}

FileOutputStream fOut = new FileOutputStream(xlsName);

try {

workbook.write(fOut);

fOut.flush();

} catch (Exception e) {

e.printStackTrace();

}finally {

if(fOut != null){

fOut.close();

}

}

return 1;

}

四、设置提示下载弹出框

FileInputStream fis = new FileInputStream(new File(file));

OutputStream os = response.getOutputStream();

response.setHeader(\"Content-Disposition\",\"attachment;filename=\"+new String(fileName.getBytes(\"gb2312\"),\"iso8859-1\"));

response.setCharacterEncoding(\"utf-8\");

int j = 0;

byte[] b = new byte[8192];

while ((j = fis.read(b, 0, 8192)) != -1)

{

os.write(b, 0, j);

}

os.flush();

fis.close();

注：fileName.getBytes(\"gb2312\"),\"iso8859-1\")是解决文件名中文乱码的问题；

详见InitAction和CommonMethod文件中方法；