poi插件进行excel表格输出的使用

首先项目中需要导入:直接看代码。

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);
	}

}


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值