首先项目中需要导入:直接看代码。
public class Output extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
HttpSession session=req.getSession();
System.out.println("****************");
String exportFileName = "签到表.xls";
Workbook wb = new HSSFWorkbook();// 创建工作簿
Sheet createSheet = wb.createSheet("first");
Row row = createSheet.createRow(0);
String[] cellTitle = { "编号", "姓名", "学号", "签到时间", "ip地址" };
for (int i = 0; i < cellTitle.length; i++) {
createSheet.setColumnWidth(i, 3500);
Cell createCell = row.createCell(i);
createCell.setCellValue(cellTitle[i]);
}
Vector stu = (Vector) session.getAttribute("student");
System.out.println(stu.size());
for (int i = 0; i < stu.size(); i++) {
Qstudent student = (Qstudent) stu.get(i);
Row dataRow = createSheet.createRow((short) i+1);
for (int j = 0; j < cellTitle.length; j++) {
Cell dataCell = dataRow.createCell(j);
switch (j) {
case 0:
dataCell.setCellValue(student.getId());
break;
case 1:
dataCell.setCellValue(student.getQ_name());
break;
case 2:
dataCell.setCellValue(student.getQ_xuehao());
break;
case 3:
dataCell.setCellValue(student.getQ_date());
break;
case 4:
dataCell.setCellValue(student.getQ_ip());
break;
}
}
}
resp.setHeader("Content-Disposition", "attachment;filename="
+ new String((exportFileName).getBytes(), "ISO8859-1"));// 设定输出文件头
resp.setContentType("application/vnd.ms-excel;charset=UTF-8");// 定义输出类型
OutputStream out = resp.getOutputStream();
wb.write(out);
out.flush();
out.close();
// RequestDispatcher dispatcher = req.getRequestDispatcher("/index.jsp");
// dispatcher.forward(req, resp);
// TODO Auto-generated method stub
// super.doGet(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
super.doPost(req, resp);
}
}