日期:2014-05-16  浏览次数:20369 次

Ext的grid如何导出excel????
找了好久,都没有找到

------解决方案--------------------

var Base64 = (function() {
var keyStr = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=";
function 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;
}
return {
encode: function (input) {
var output = "";
var chr1, chr2, chr3, enc1, enc2, enc3, enc4;
var i = 0;
input = utf8Encode(input);
while (i < input.length) {
chr1 = input.charCodeAt(i++);
chr2 = input.charCodeAt(i++);
chr3 = input.charCodeAt(i++);
enc1 = chr1 >> 2;
enc2 = ((chr1 & 3) << 4) | (chr2 >> 4);
enc3 = ((chr2 & 15) << 2) | (chr3 >> 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 *<xml version="1.0" encoding="utf-8">* +
*<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office">* +
*<o:DocumentProperties><o:Title>* + this.title + *</o:Title></o:DocumentProperties>* +
*<ss:ExcelWorkbook>* +
*<ss:WindowHeight>* + worksheet.height + *</ss:WindowHeight>* +
*<ss:WindowWidth>* + worksheet.width + *</ss:WindowWidth>* +
*<ss:ProtectStructure>False</ss:ProtectStructure>* +
*<ss:ProtectWindows>False</ss:ProtectWindows>* +
*</ss:ExcelWorkbook>* +
*<ss:Styles>* +
*<ss:Style ss:ID="Default">* +
*<ss:Alignment ss:Vertical="Top" ss:WrapText="1" />* +
*<ss:Font ss:FontName="arial" ss:Size="10" />* +
*<ss:Borders>* +
*<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Top" />* +
*<ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Bottom" />* +
*<ss:Border ss:Color="#e4e4e4" s