Extjs前台导出数据.docx

/* * allows for downloading of grid data (store) directly into excel * Method: extracts data of gridPanel store, uses columnModel to construct XML excel document, * converts to Base64, then loads everything into a data URL link. * * authorAnimal * */* * base64 encode / decode * * location / * */var Base64 = (function() / Private property var keyStr = ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=; / Private method for UTF-8 encoding function utf8Encode(string) string = string.replace(/rn/g,n); var utftext = ; for (var n = 0; n string.length; n+) var c = string.charCodeAt(n); if (c 127) & (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 encoding return encode : (typeof btoa = function) ? function(input) return btoa(utf8Encode(input); : function (input) var output = ; var chr1, chr2, chr3, enc1, enc2, enc3, enc4; var i = 0; input = utf8Encode(input); while (i 2; enc2 = (chr1 & 3) 4); enc3 = (chr2 & 15) 6); enc4 = chr3 & 63; if (isNaN(chr2) enc3 = enc4 = 64; else if (isNaN(chr3) enc4 = 64; output = output + keyStr.charAt(enc1) + keyStr.charAt(enc2) + keyStr.charAt(enc3) + keyStr.charAt(enc4); return output; ;)();Ext.override(Ext.grid.GridPanel, getExcelXml: function(includeHidden) var worksheet = this.createWorksheet(includeHidden); var totalWidth = this.getColumnModel().getTotalWidth(includeHidden); return + + + this.title + + + + worksheet.height + + + worksheet.width + + False + False + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + worksheet.xml + ; , createWorksheet: function(includeHidden) / Calculate cell data types and extra class names which affect formatting var cellType = ; var cellTypeClass = ; var cm = this.getColumnModel(); var totalWidthInPixels = 0; var colXml = ; var headerXml = ; var visibleColumnCountReduction = 0; var colCount = cm.getColumnCount(); for (var i = 0; i colCount; i+) if (cm.getDataIndex(i) != ) & (includeHidden | !cm.isHidden(i) var w = cm.getColumnWidth(i) totalWidthInPixels += w; if (cm.getColumnHeader(i) = ) cellType.push(None); cellTypeClass.push(); +visibleColumnCountReduction; else colXml += ; headerXml += + + cm.getColumnHeader(i) + + ; var fld = this.store.recordTtotype.fields.get(cm.getDataIndex(i); switch(fld.type) case int: cellType.push(Number); cellTypeClass.push(int); break; case float: cellType.push(Number); cellTypeClass.push(float); break; case bool: case boolean: cellType.push(String); cellTypeClass.push(); break; case date: cellType.push(DateTime); cellTypeClass.push(date); break; default: cellType.push(String); cellTypeClass.push(); break; var visibleColumnCount = cellType.length - visibleColumnCountReduction; var result = height: 9000, width: Math.floor(totalWidthInPixels * 30) + 50 ; / Generate worksheet header details. var t = + + + + + colXml + + + + + + + + headerXml + ; / Generate the data rows from the data in the Store for (var i = 0, it = this.store.data.items, l = it.length; i l; i+) t += ; var cellClass = (i & 1) ? odd : even; r = iti.data; var k = 0; for (var j = 0; j colCount; j+) if (cm.getDataIndex(j) != ) & (includeHidden | !cm.isHidden(j) var v = rcm.getDataIndex(j); if (cellTypek != None) t += ; if (