...
代码块 | ||||
---|---|---|---|---|
| ||||
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 } } |
2、实现点击导出按钮直接导出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");
}
} |