java pageoffice 导出e_java pageoffice使用，生成导出excel报表

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);

}