把数据从网页中直接导入到excel中,下面就上代码。
页面js中导出的方法:
function exportExcel() {
var queryPara = sy.serializeObject($('#agendaForm'));
var url = BASE_URL+"exportExcel.do?queryPara=" + JSON.stringify(queryPara) ;
window.location.href = url;
}
html页面的代码:
<form id="agendaForm" name="agendaForm" method="post">
<table id="agendatable" class="table table-bordered">
<tr>
<td align="right">开始时间 </td>
<td colspan="3">
<input id="aaId" name="aaId" hidden/>
<input id="aiId" name="aiId" value="1" hidden/>
<input name="starttime" value="starttime" style="width:400px;">
</td>
</tr>
<tr>
<td align="right">结束时间 </td>
<td colspan="3">
<input name="endtime" value="endtime" style="width:400px;">
</td>
</tr>
<tr>
<td align="right">活动内容 </td>
<td colspan="3">
<input name="content" value="content" style="width:400px;">
</td>
</tr>
<tr>
<td align="right">演讲嘉宾 </td>
<td colspan="3"><input name="speaker" value="speaker" style="width:400px;"></td>
</tr>
</form>
controller层
@RequestMapping(value = "/exportExcel.do")
public void exportExcel(HttpServletRequest request,HttpServletResponse response) {
String queryPara = request.getParameter("queryPara");
JSONUtils.getMorpherRegistry().registerMorpher(
new DateMorpherEx(new String[] { "yyyy-MM-dd" },
(Date) null));
JSONObject jo = JSONObject.fromObject(queryPara);
ActivityAgenda activityAgenda = (ActivityAgenda)JSONObject.toBean(jo,ActivityAgenda.class);
/*if(jo.containsKey("time") && !StringUtils.isEmpty(jo.getString("time")))
activityAgenda.setTime(DateHandler.strToDate(jo.getString("time"), "yyyy-MM-dd"));*/
try {
String excelFileName = new String((DateHandler.dateToStr(new Date(),"yyyyMMddhhmmss")+".xls").getBytes("gb2312"), "ISO88