Java导出表格

//第一步，创建一个webbook，对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
//第二步。在webbook中添加一个sheet，对应Excel文件
HSSFSheet sheet = wb.createSheet("入库记录表");
sheet.setDefaultColumnWidth(20);//表格设置默认的宽度
sheet.setDefaultRowHeightInPoints(20);//表格的行高
//第三步，在sheet中添加表头第0行
HSSFRow row = sheet.createRow((int)0);
//第四步，创建单元格，并设置表头，设置表头居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//创建一个居中格式
//背景色
style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index);

//自动换行
style.setWrapText(true);
//生成一个字体
HSSFFont font = wb.createFont();
font.setColor(HSSFColor.BLACK.index);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
//把字体应用到当前样式
style.setFont(font);
//style设置好后，为cell设置样式
HSSFCell cell = row.createCell((short) 0);
cell.setCellValue("入库的仓库");
cell.setCellStyle(style);
cell = row.createCell((short) 1);
cell.setCellValue("时间");
cell.setCellStyle(style);
cell = row.createCell((short) 2);
cell.setCellValue("产品名");
cell.setCellStyle(style);
cell = row.createCell((short) 3);
cell.setCellValue("规格");
cell.setCellStyle(style);
cell = row.createCell((short) 4);
cell.setCellValue("数量");
cell.setCellStyle(style);
cell = row.createCell((short) 5);
cell.setCellValue("单价");
cell.setCellStyle(style);
//写入实体数据，实际应用中这些数据从数据库得到
for (int i = 0; i < listTotal.size(); i++) {
   row = sheet.createRow((int)i+1);
   inWarehouse obj = listTotal.get(i);
   // 第四步，创建单元格，并设置值
   row.createCell((short) 0).setCellValue(obj.getInWarehouse());
   row.createCell((short) 1).setCellValue(obj.getInTime());
   row.createCell((short) 2).setCellValue(obj.getProName());
   row.createCell((short) 3).setCellValue(obj.getProGuige());
   row.createCell((short) 4).setCellValue(obj.getProNumber());
   row.createCell((short) 5).setCellValue(obj.getProSinglePrice()+"元/"+obj.getPriceUnit());
   cell.setCellStyle(style);
}
//第六步，将文件存在指定位置
try {
   response.setHeader("content-disposition","attachment;filename="+ URLEncoder.encode("入库记录表.xls", "utf-8"));
   ServletOutputStream os = response.getOutputStream();
   //FileOutputStream font = new FileOutputStream("D:/入库记录表");
   wb.write(os);
   os.close();
} catch (Exception e) {
   e.printStackTrace();
}