poi实现java导出成绩表到excel

private void scoreToExcel(HttpServletRequest request,
HttpServletResponse response, PrintWriter out)
throws ServletException, IOException {
TeacherDao teacherDao = new TeacherDao();

//查询所有学生成绩信息
List<Map<String,Object>> scoreList = teacherDao.getScoreList();
if (!CollectionUtil.isEmpty(scoreList)) {
//在Excel中建立工作表
HSSFWorkbook workbook = new HSSFWorkbook();

//2.导出文件名为学生成绩表
HSSFSheet sheet = workbook.createSheet("学生成绩表"); 
/**
* 第一行表头数据
*/
HSSFRow row = sheet.createRow((int)0);
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);
//定义单元格为字符串类型，这个字符串类型也可在创建单元格里面设置。
cell1.setCellType(HSSFCell.CELL_TYPE_STRING); 
cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
cell3.setCellType(HSSFCell.CELL_TYPE_STRING); 
cell4.setCellType(HSSFCell.CELL_TYPE_STRING); 
cell5.setCellType(HSSFCell.CELL_TYPE_STRING); 
cell6.setCellType(HSSFCell.CELL_TYPE_STRING);
cell7.setCellType(HSSFCell.CELL_TYPE_STRING); 
//在单元格中输入一些内容
cell1.setCellValue("学号"); 
cell2.setCellValue("试卷名");
cell3.setCellValue("单选得分");
cell4.setCellValue("多选得分");
cell5.setCellValue("判断得分");
cell6.setCellValue("考试总分");
cell7.setCellValue("考试结果");

/**
*  根据查询到的成绩信息的列数，统计excel行数，并填充数据
*/
//得到excel行数
int count = scoreList.size();
//根据score行数判断
for(int i=0;i<count;i++){
row = sheet.createRow((int)i+1);
        
        //创建单元格，并设置值
        row.createCell((short)0).setCellValue((String)scoreList.get(i).get("student_no"));
        row.createCell((short)1).setCellValue((String)scoreList.get(i).get("paper_name"));
        row.createCell((short)2).setCellValue((Integer)scoreList.get(i).get("single_score"));
        row.createCell((short)3).setCellValue((Integer)scoreList.get(i).get("multi_score"));
        row.createCell((short)4).setCellValue((Integer)scoreList.get(i).get("judge_score"));
        row.createCell((short)5).setCellValue((Integer)scoreList.get(i).get("total_score"));
        row.createCell((short)6).setCellValue((String)scoreList.get(i).get("result"));
   }

//新建一输出文件流，把相应的Excel工作簿 输出到本地
FileOutputStream fOut = new FileOutputStream("e:\\学生成绩表.xls");

workbook.write(fOut);

fOut.close();
fOut.flush();
out.print("<script>alert('导出学生成绩成功，请到E盘根目录查看');location.href='TeacherServlet?action=L0100001&flag=';</script>");
} else {
out.print("<script>alert('学生成绩信息为空，无法导出学生成绩');location.href='TeacherServlet?action=L0100001&flag=';</script>");
}
}