Jquery-easyui-datagrid-js导出excel.doc

Jquery easyui datagrid js导出excel
修改自extgrid导出excel
/**
* 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.
*
* @author Animal
*
*/

$.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=1; i' +
'' +
'' + param.title + '' +
'' +
'' + worksheet.height + '' +
'' + worksheet.width + '' +
'False' +
'False' +
'' +
'tyles>' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'e>' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
'' +
worksheet.xml +
'';
},

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 = 1; 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 = '' +
'' +
'' +
'' +
'' +
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++) {
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 = 1; 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 + '' +
'' +
'' +
'' +
'ter x:Data="Page &P of &N" x:Margin="0.5" />' +
'' +
'' +
'' +
'' +
'Blank' +
'1' +
'32767' +
'' +
'600' +
'' +
'' +
'' +
'False' +
'False' +
'' +
'';
//alert(result.xml);
return result;
}
});