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语句输出的表格，修改为从数据库获取数据。这个例子可以用于应用较为简单的场合。