综述:在lifery开发的时候需要将后台的数据以excel的形式从页面上导出。
1.在代码中设置流返回的头形式:
ResourceResponse portletResponse = (ResourceResponse)PortletActionContext.getResponse();
HttpServletResponse response = PortalUtil.getHttpServletResponse(portletResponse);
response.setCharacterEncoding("UTF-8");
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=\""
+ "jiatingExport_"+statu+"_"+ ".xls\"");
WritableWorkbook wwb = Workbook.createWorkbook(response.getOutputStream());
WritableSheet ws = wwb.createSheet("OrderExport", 0);
ws.addCell(new Label(0,0,"序号"));
.....
2.在页面上显示执行执行导出操作的步骤:
<td><s:submit value="导出" οnclick="return %{portletNamespace}.exportABC();"/></td>
3.javascript的写法:
function popUpWindow(url) {
var newwindow=window.open(url,'_blank','height=600,width=1000');
if (window.focus) {newwindow.focus()}
return newwindow;
}
var <portlet:namespace/>=function() {
var baseXjUrl='<s:url action="OrderExportSave" portletUrlType="resource" />';
return {
exportABC: function() {
var param = jQuery("#xjFmOrderExport").formSerialize()
var actionUrl = baseXjUrl+'&'+param
popUpWindow(actionUrl);
return false;
},
};
}();
4.以上是lifery开发中从页面导出excel的方法。其实在普通的web项目中也可以采用这种方法来从页面导出excel文件!
1.在代码中设置流返回的头形式:
ResourceResponse portletResponse = (ResourceResponse)PortletActionContext.getResponse();
HttpServletResponse response = PortalUtil.getHttpServletResponse(portletResponse);
response.setCharacterEncoding("UTF-8");
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=\""
+ "jiatingExport_"+statu+"_"+ ".xls\"");
WritableWorkbook wwb = Workbook.createWorkbook(response.getOutputStream());
WritableSheet ws = wwb.createSheet("OrderExport", 0);
ws.addCell(new Label(0,0,"序号"));
.....
2.在页面上显示执行执行导出操作的步骤:
<td><s:submit value="导出" οnclick="return %{portletNamespace}.exportABC();"/></td>
3.javascript的写法:
function popUpWindow(url) {
var newwindow=window.open(url,'_blank','height=600,width=1000');
if (window.focus) {newwindow.focus()}
return newwindow;
}
var <portlet:namespace/>=function() {
var baseXjUrl='<s:url action="OrderExportSave" portletUrlType="resource" />';
return {
exportABC: function() {
var param = jQuery("#xjFmOrderExport").formSerialize()
var actionUrl = baseXjUrl+'&'+param
popUpWindow(actionUrl);
return false;
},
};
}();
4.以上是lifery开发中从页面导出excel的方法。其实在普通的web项目中也可以采用这种方法来从页面导出excel文件!