JAVA EXCEL API的使用
使用Java Excel API生成Excel,以下是做了一个简单的例子(官方文档)public class JavaExcelAPI extends HttpServlet {private static final long serialVersionUID = 1L;@Overrideprotected 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();}}}
页:
[1]