Ext4.1.1a导出Excel.docx

Ext4.1.1a实现Excel导出做应用时我们总会遇到这样的问题既导出Excel表格。如果前台我们使用Ext我们该如何做呢？首先实现Excel导出有这么两类：后台生成前台直接打印本文就第二类来谈一谈Ext4.1.1的具体实现思路：遍历gridPanel的store取的每一行每一列的数据将数据用xml格式包装成字符串（例如：ss:Tabless:Rowss:Cellss:Data/ss:Data/ss:Cell/ss:Row/ss:Table）将字符串转换为Base64编码（假设存入变量base64Code）4.拼凑url, var url=data:application/vnd.ms-excel;base64,+base64Code5.通过执行window.location = url完成下载;通过以上思路完成了Exporter2Excel-all.js封装好了大部分功能，运行效果如图:Exporter2Excel-all.js介绍与用法：功能：通过ExtJs导出gridPanel当前页面的内容。支持的浏览器：360极速浏览器，谷歌浏览器用法（首先要导入Exporter2Excel-all.js）：通过创建button增加事件处理函数：function() {var url = getExcelUrl.getExcelUrl(grid, meng);window.location = url;}完成Excel导出。例如：var menuPanel = Ext.create(Ext.panel.Panel, {region : south,title : ,width : 1000,buttons : [{width : 250,xtype : button,text : 打印,handler : function() {var url = getExcelUrl.getExcelUrl(grid, meng);window.location = url;}}]});当“打印”按钮被点击时就会触发事件处理函数，从而完成下载。Exporter2Excel-all.js内容如下：var getExcelUrl = (function() {//Base64编码转换函数，用法Base64.encode(string)var Base64 = (function() {// private propertyvar keyStr = ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=;// private method for UTF-8 encodingfunction utf8Encode(string) {string = string.replace(/\r\n/g, \n);var utftext = ;for (var n = 0; n string.length; n++) {var c = string.charCodeAt(n);if (c 128) {utftext += String.fromCharCode(c);} else if ((c 127) (c 2048)) {utftext += String.fromCharCode((c 6) | 192);utftext += String.fromCharCode((c 63) | 128);} else {utftext += String.fromCharCode((c 12) | 224);utftext += String.fromCharCode(((c 6) 63) | 128);utftext += String.fromCharCode((c 63) | 128);}}return utftext;}// public method for encodingreturn {// This was the original line, which tries to use Firefoxs built in// Base64 encoder, but this kept throwing exceptions....// encode : (typeof btoa == function) ? function(input) { return// btoa(input); } : function (input) {encode : function(input) {var output = ;var chr1, chr2, chr3, enc1, enc2, enc3, enc4;var i = 0;input = utf8Encode(