在报表宏界面,新建客户端模块,在弹出的新建模块对话框中,选择对象为spreadSheetReport,事件为onRenderReport
导出选项设置
function main(spreadsheetReport) {
//旧方法备份
spreadsheetReport._initExportMenu_new = spreadsheetReport.initExportMenu;
//重写方法
spreadsheetReport.initExportMenu = function() {
spreadsheetReport._initExportMenu_new();
this.exportMenu.removeItem("CSV"); //屏蔽CSV
this.exportMenu.removeItem("HTML"); //屏蔽HTML
this.exportMenu.removeItem("PNG"); //屏蔽PNG
this.exportMenu.removeItem("PDF"); //屏蔽PDF
this.exportMenu.removeItem("WORD"); //屏蔽WORD
//this.exportMenu.removeItem("EXCEL2007"); //屏蔽EXCEL
}
}
导出为excel
function main(spreadsheetReport) {
//旧方法备份
spreadsheetReport._initExportMenu_new = spreadsheetReport.initExportMenu;
//重写方法
spreadsheetReport.initExportMenu = function() {
spreadsheetReport._initExportMenu_new();
this.exportMenu.removeItem("CSV"); //屏蔽CSV
this.exportMenu.removeItem("HTML"); //屏蔽HTML
this.exportMenu.removeItem("PNG"); //屏蔽PNG
this.exportMenu.removeItem("PDF"); //屏蔽PDF
this.exportMenu.removeItem("WORD"); //屏蔽WORD
//this.exportMenu.removeItem("EXCEL2007"); //屏蔽EXCEL
}
spreadsheetReport.old_doExport = spreadsheetReport.doExport;
spreadsheetReport.doExport = function() {
/*this.old_doExport();
this.exportMenu.panel.style.height = "";*/
//上面是高度自适应,下面是点击直接调用导出excel
this.doExportMenuCloseUp("EXCEL2007");
//若是清单报表:this.doExportMenuCloseUp("LIST_EXCEL");
}
}