一、JSP 文件
< div id="content" >
<table id="dg" title="Menu Hits" class="easyui-datagrid" style="height:600px" url="${ctx}/json/getName.action"
toolbar ="#toolbar" pagination ="true" pageList ="[5,10,15]"
< thead>
<tr>
</thead >
<div id=”toolbar”>
<a href=”class=”easyui-linkbutton” iconCls=”icon-save” plain=”true” onClick=”exportExcel()”> Excel </a>
</div>
<script type=”text/javascript”>
function exportExcel(){
var date=$(“#date”).datebox(“getValue”);
var text=$(“#txtId”).val();
location.href
} </script>
</div>
二、struts 文件
<action name=”exportExcel” class=”exportAction” method=”exportExcel”>
<result name=”success” type=”stream” >
<param name=”contentType”>application/vnd.ms-excel</param>
<param name=”inputName”> excelStream</param>
<param name=”contentDispostion”>attachment;filename=”$(fileName).xls”</param>
<param name=”bufferSize”>1024</param>
</result >
</action>
三、java 文件
searchInput = new SysName(); // SysName 是一个 Model 对应数据库文件
searchInput.setName(name); // JSP 中传送的 parameter
List name= nameService.search(searchInput, date); // 读取数据库
HSSFWorkbook workbook = getWorkbook(name, date);
ByteArrayOutputStream baos = new ByteArrayOutputStream();
workbook.write(baos);
baos.flush();
byte[] aa = baos.toByteArray();
excelStream = new ByteArrayInputStream(aa, 0, aa.length);
baos.close();
return SUCCESS;
}
1.
2. getWorkbook() - 生成EXCEL表
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet1 = workbook.createSheet("Total"); //包含两个sheet页
HSSFSheet sheet2 = workbook.createSheet("Details");
HSSFRow row = sheet1.createRow(0);
HSSFCell cell