Extjs导出Grid数据到Excel

1、调用方式
var excel = new Ext.Excel({
    gridId: 'gridId',--GridId
    sheetName: 'sheetName',--sheetName
    dsIndex:'oprDate','bizKey','custAbbr','refNo','amount','status','bizItemCn','registerOpAuth','attachCnt','isInCot','remark']--数据源
});
excel.extGridToExcel();--调用方法

2、Export.js
/*
*功能：直接由Ext的grid生成Excel
*注意：只支持IE
*参数：gridId, sheetName 
*/
Ext.Excel = function(config){
   Ext.apply(this,config);
};

Ext.ExcelNew = function(config){
   Ext.apply(this,config);
};

Ext.apply(Ext.Excel.prototype,{
extGridToExcel : function(){ 
try { 
if (Ext.getCmp(this.gridId)) { 
// grid 生成 Excel
var oXL = new ActiveXObject("Excel.Application");  
var oWB = oXL.Workbooks.Add();  
var oSheet = oWB.ActiveSheet;  
var grid = Ext.getCmp(this.gridId); 
var store = grid.getStore(); 
var recordCount = store.getCount(); 
var view = grid.getView(); 
var cm = grid.getColumnModel(); 
var colCount = cm.getColumnCount(); 
var temp_obj = []; 
for (var i = 0; i < colCount;i++) {
if (this.dsIndex) {
for(var xi=0; xi < this.dsIndex.length; xi++){
if (this.dsIndex[xi] == cm.config[i].dataIndex){
temp_obj.push(i);
break;
}
}
} else {
if (cm.isHidden(i)) { 

} else { 
temp_obj.push(i); 
} 
}
} 
for (var i = 1; i <= temp_obj.length;i++) {
oSheet.Cells(1,i).value = cm.getColumnHeader(temp_obj[i - 1]); 
} 
                         
for(var i = 1 ; i <= recordCount; i++) {
for(var j = 1; j<= temp_obj.length; j++) {
oSheet.Cells(i+1,j).value = view.getCell(i-1,temp_obj[j-1]).innerText;  
} 
} 
    oSheet.Columns.AutoFit;
if (this.sheetName){ 
oSheet.Name = this.sheetName; 
} 
oXL.UserControl = true; 
oXL.Visible = true; 
} else { 
Ext.Msg.show({
title : '错误',
msg : '明细数据导出失败!',
buttons : Ext.Msg.OK, 
icon : Ext.Msg.ERROR 
}); 
return; 
}        
}catch(e){ 
if (Ext) { 
Ext.Msg.show({ 
title : '提示', 
msg : '请设置IE的菜单\'工具\'->Internet选项->安全->自定义级别->\'对未标记为可安全执行脚本ActiveX控件初始化并执行脚本\'->选择[启用]&nbsp;&nbsp;就可以生成Excel',
buttons : Ext.Msg.OK, 
icon : Ext.Msg.INFO 
}); 
} else { 
alert('不支持ExtJs框架'); 
return; 
} 
}
}
});


Ext.apply(Ext.ExcelNew.prototype,{
extGridToExcel : function(){ 
try { 
if (Ext.getCmp(this.gridId)) {
var oXL = new ActiveXObject("Excel.Application");  
var oWB = oXL.Workbooks.Add();  
var oSheet = oWB.ActiveSheet;  
var grid = Ext.getCmp(this.gridId);
var dsIndexs = this.dsIndex;
var store = grid.getStore(); 
var recordCount = store.getCount(); 
var view = grid.getView(); 
var cm = grid.getColumnModel(); 
var colCount = cm.getColumnCount(); 
var temp_obj = []; 
for (var i = 0; i < colCount;i++) {
var cmConfig = cm.config;
for(var xi=0;xi<dsIndexs.length;xi++){
if(dsIndexs[xi]==cmConfig[i].dataIndex){
temp_obj.push(i);
break;
}
}
} 
for (var i = 1; i <= temp_obj.length;i++) {
oSheet.Cells(1,i).value = cm.getColumnHeader(temp_obj[i - 1]); 
} 
                         
for(var i = 1 ; i <= recordCount; i++) {
for(var j = 1; j<= temp_obj.length; j++) {
oSheet.Cells(i+1,j).value = view.getCell(i-1,temp_obj[j-1]).innerText;  
} 
} 
if (this.sheetName){ 
oSheet.Name = this.sheetName; 
} 
oXL.UserControl = true; 
oXL.Visible = true; 
} else { 
Ext.Msg.show({
title : '错误',
msg : '明细数据导出失败!',
buttons : Ext.Msg.OK, 
icon : Ext.Msg.ERROR 
}); 
return; 
}        
}catch(e){ 
if (Ext) { 
Ext.Msg.show({ 
title : '提示', 
msg : '请设置IE的菜单\'工具\'->Internet选项->安全->自定义级别->\'对未标记为可安全执行脚本ActiveX控件初始化并执行脚本\'->选择[启用]&nbsp;&nbsp;就可以生成Excel',
buttons : Ext.Msg.OK, 
icon : Ext.Msg.INFO 
}); 
} else { 
alert('不支持ExtJs框架'); 
return; 
} 
} 
}
});