table中的数据是sql查询所得，可同时执行多条sql语句；
百度搜索poi，随便找个例子就行
用 apache poi， 我刚写了 poi excel export， 还未审核， 这是我的第一篇博客 url: http://blog.csdn.net/qq_23039605/article/details/52402522
明早应该通过审核，你可以看一下， 希望对你有帮助。
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page contentType="application/vnd.ms-excel; charset=gbk" %>
<%@page import="java.text.SimpleDateFormat"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
SimpleDateFormat sf = new SimpleDateFormat("yyyyMMddkkmmssSSS");
String filename = new String(("文件名字-"+sf.format(new Date())).getBytes("gbk"),"ISO-8859-1");
response.addHeader("Content-Disposition", "filename=" + filename + ".xls");
%>
<%@ taglib prefix="c" uri="/WEB-INF/c.tld" %>
<%@ page isELIgnored="false"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
| XX | XX | XX | XX | XX | XX | XX> | XX | |
|---|---|---|---|---|---|---|---|---|
| ${calRecordList.callnum} | ${calRecordList.toCallnum} | ${calRecordList.calltype} | ${calRecordList.talktime} | ${calRecordList.billtime} | ${calRecordList.fee} | ${calRecordList.groupid} |