easyui datagrid导出Excel 有什么好的解决方法吗

首先在js中写一个扩展类，主要的功能是把DataGrid中的数据转换成Excel的XML格式
'''将datagrid中的数据转换成Excel的XML格式'''

$.extend($.fn.datagrid.methods, {
getExcelXml: function (jq, param) {
var worksheet = this.createWorksheet(jq, param);
//alert($(jq).datagrid('getColumnFields'));
var totalWidth = 0;
var cfs = $(jq).datagrid('getColumnFields');
for (var i = 0; i < cfs.length; i++) {
totalWidth += $(jq).datagrid('getColumnOption', cfs[i]).width;
}
//var totalWidth = this.getColumnModel().getTotalWidth(includeHidden);
return '' +
'' +
'' + param.title + '' +
'' +
'' + worksheet.height + '' +
'' + worksheet.width + '' +
'False' +
'False' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
worksheet.xml +
'';
},

'''创建worksheet，将dataGrid的标题放到里面'''
createWorksheet: function (jq, param) {
'''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 cfs = $(jq).datagrid('getColumnFields');
var colCount = cfs.length;
for (var i = 0; i < colCount; i++) {
if (cfs[i] != '') {
var w = $(jq).datagrid('getColumnOption', cfs[i]).width;
totalWidthInPixels += w;
if (cfs[i] === "") {
cellType.push("None");
cellTypeClass.push("");
++visibleColumnCountReduction;
}
else {
colXml += '';
headerXml += '' +
'' + $(jq).datagrid('getColumnOption', cfs[i]).title + '' +
'';
cellType.push("String");
cellTypeClass.push("");
}
}
}
var visibleColumnCount = cellType.length - visibleColumnCountReduction;

var result = {
height: 9000,
width: Math.floor(totalWidthInPixels * 30) + 50
};

var rows = $(jq).datagrid('getRows');
// Generate worksheet header details.
var t = '' +
'' +
'' +
'' +
' ' ss:ExpandedColumnCount="' + (visibleColumnCount + 2) +
'" ss:ExpandedRowCount="' + (rows.length + 2) + '">' +
colXml +
'' +
headerXml +
'';

//将DataGrid的数据循环加入到Excel中
//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++) {
for (var i = 0, it = rows, l = it.length; i < l; i++) {
t += '';
var cellClass = (i & 1) ? 'odd' : 'even';
r = it[i];
var k = 0;
for (var j = 0; j < colCount; j++) {
//if ((cm.getDataIndex(j) != '')
if (cfs[j] != '') {
//var v = r[cm.getDataIndex(j)];
var v = r[cfs[j]];
if (cellType[k] !== "None") {
t += '';
if (cellType[k] == 'DateTime') {
t += v.format('Y-m-d');
} else {
t += v;
}
t += '';
}
k++;
}
}
t += '';
}

result.xml = t + '' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'Blank' +
'1' +
'32767' +
'' +
'600' +
'' +
'' +
'' +
'False' +
'False' +
'' +
'';
//alert(result.xml);
return result;
}
});

然后再新建一个一般处理程序
public void ProcessRequest(HttpContext context) {
'''给要下载的Excel赋一个初始的文件名'''
string fn = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";
'''获取前台传回来的值，应该是一个XML文件的内容''''
string data = context.Request.Form["data"];
'''将相对路径转换为绝对路径，数据，编码方式'''
File.WriteAllText(context.Server.MapPath(fn), data, Encoding.UTF8);'''如果是gb2312的xml申明，第三个编码参数修改为Encoding.GetEncoding(936)'''

context.Response.Write(fn);'''返回文件名提供下载'''
}