JAVA EXCEL API的使用

使用Java Excel API生成Excel,以下是做了一个简单的例子(官方文档)

public class JavaExcelAPI extends HttpServlet {

	private static final long serialVersionUID = 1L;

	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		super.doGet(req, resp);
		ServletOutputStream os = resp.getOutputStream();

		resp.reset();
		resp.setContentType("application/vnd.ms-excel;charset=UTF-8");
		resp.setHeader("Content-Disposition", "attachment; filename="
				+ new String("name".getBytes(), "iso-8859-1") + ".xls");

		WritableWorkbook workbook = Workbook.createWorkbook(os);
		WritableSheet sheet = workbook.createSheet("name", 0);
		int col = 0, row = 0, col2 = 1;
		try {
			sheet.addCell(new Label(col, row, "cont"));
			sheet.addCell(new Label(col2, row, "cont"));
			sheet.mergeCells(col, row, col2, row);
			workbook.write();
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		} finally {
			try {
				workbook.close();
			} catch (WriteException e) {
				e.printStackTrace();
			}
			os.flush();
			os.close();
		}
	}
}