web.xml的配置
poserver
com.zhuozhengsoft.pageoffice.poserver.Server
poserver
/poserver.zz
poserver
/poserver.do
poserver
/pageoffice.cab
poserver
/popdf.cab
poserver
/sealsetup.exe
poserver
/posetup.exe
adminseal
com.zhuozhengsoft.pageoffice.poserver.AdminSeal
adminseal
/adminseal.do
adminseal
/loginseal.do
adminseal
/sealimage.do
mht
message/rfc822
adminseal-password
111111
后台java代码
public String entrustMonthSum(HttpServletRequest request,String sdate,String edate) {
UserFormMap user = (UserFormMap) Common.findUserSession(request);
String orgid="0";
if(null!=user){
orgid = String.valueOf(user.get("orgid"));
}
if (Common.isEmpty(sdate)) {
Date date= new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-01");
sdate=sdf.format(date);
}
if (Common.isEmpty(edate)) {
edate="3000-12-31";
}
List> list = surveyDistributMapper.getEntrustMonthSum(sdate, edate,orgid);
PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
poCtrl1.setServerPage(request.getContextPath()+"/poserver.zz"); //此行必须
Workbook workBook = new Workbook();
Sheet sheet = workBook.openSheet("Sheet1");
Table table = sheet.openTable("A3:H3");
for(int i=0; i< list.size(); i++)
{
//向excel填充数据
Map map=list.get(i);
table.getDataFields().get(0).setValue(map.get("create_time"));
table.getDataFields().get(1).setValue(map.get("address")!=null?map.get("address"):"");
table.getDataFields().get(2).setValue(map.get("intermediary_name")!=null?map.get("intermediary_name"):"");
table.getDataFields().get(3).setValue(map.get("bank")!=null?map.get("bank"):"");
table.getDataFields().get(4).setValue(map.get("subbank")!=null?map.get("subbank"):"");
table.getDataFields().get(5).setValue(map.get("evaluateType")!=null?map.get("evaluateType"):"");
table.getDataFields().get(6).setValue(map.get("orgname")!=null?map.get("orgname"):"");
table.getDataFields().get(7).setValue(map.get("isover"));
table.nextRow();
}
table.close();
poCtrl1.setWriter(workBook);
//隐藏菜单栏
poCtrl1.setMenubar(false);
//隐藏工具栏
//poCtrl1.setCustomToolbar(false);
poCtrl1.setOfficeToolbars(false);
poCtrl1.addCustomToolButton("保存", "SaveDocuments()", 1);//SaveDocuments与jsp页面中的js函数名字一致,数字代表的是对应的图标
poCtrl1.addCustomToolButton("-", "", 0);
poCtrl1.addCustomToolButton("打印", "ShowPrintDlg()", 6);
poCtrl1.addCustomToolButton("-", "", 0);
poCtrl1.addCustomToolButton("全屏切换", "SetFullScreen()", 4);
poCtrl1.addCustomToolButton("-", "", 0);
poCtrl1.addCustomToolButton("加盖印章", "AddSeal()", 5);
poCtrl1.addCustomToolButton("手写签批", "AddHandSign()", 5);
poCtrl1.addCustomToolButton("验证印章", "VerifySeal()", 5);
poCtrl1.setSaveFilePage("saveword.action");//保存需要执行的的action
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+request.getContextPath()+"/";
poCtrl1.webOpen(basePath+"doc/wtbb.xlsx", OpenModeType.xlsNormalEdit, String.valueOf(user.get("userName")));//excel模板
poCtrl1.setTagId("PageOfficeCtrl1"); //此行必须和前端中的id保持一致
return "view/excel/excel";//返回的jsp
}
jsp:excel.jsp
import="java.util.*,com.zhuozhengsoft.pageoffice.*,com.zhuozhengsoft.pageoffice.excelwriter.*"
pageEncoding="utf-8"%>
function SaveDocument() {
document.getElementById("PageOfficeCtrl1").ShowDialog(3);
}