JSP中输出Excel表格

下面是一个简单示例，将数据输出到score.xls表格：

@WebServlet("/downscore")public class Test1 extends HttpServlet {private static final long serialVersionUID = 1L;private static final String CONTENT_TYPE = "application/vnd.ms-download;charset=GB18030";private static final String CONTENT_FILE_NAME = "attachment;filename=score.xls";protected void service(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);response.setHeader("Content-Disposition", CONTENT_FILE_NAME);PrintWriter out = response.getWriter();out.println("<table width=300 border=1>");out.println("<tr><td>姓名</td><td>电话</td></tr>");out.println("<tr><td>张三</td><td>02787654321</td></tr>");out.println("<tr><td>李四</td><td>02786654301</td></tr>");out.println("</table>");out.close();}}

实际处理时，out语句输出的表格，修改为从数据库获取数据。这个例子可以用于应用较为简单的场合。