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. * * authorAnimal * */$.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; icfs.length; i+) totalWidth+= $(jq).datagrid(getColumnOption,cfsi).width; /var totalWidth = this.getColumnModel().getTotalWidth(includeHidden); return + + + param.title + + + + worksheet.height + + + worksheet.width + + False + False + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 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 (cfsi != ) var w = $(jq).datagrid(getColumnOption,cfsi).width; totalWidthInPixels += w; if (cfsi = ) cellType.push(None); cellTypeClass.push(); +visibleColumnCountReduction; else colXml += ; headerXml += + + $(jq).datagrid(getColumnOption,cfsi).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 = iti; var k = 0; for (var j = 1; j colCount; j+) /if (cm.getDataIndex(j) != ) if (cfsj != ) /var v = rcm.getDataIndex(j); var v = rcfsj; if (cellTypek != None) t += ; if (cellTypek = DateTime) t += v.format(Y-m-d); else t += v; t +=; k+; t += ; resu