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 extjs support team * */ $.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,cfs[i]).width; } //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:DocumentPropertieso:Title + param.title + /o:Title/o:DocumentProperties + ss:ExcelWorkbook + ss:WindowHeight + worksheet.height + /ss:WindowHeight + ss:WindowWidth + worksheet.width + /ss:WindowWidth + ss:ProtectStructureFalse/ss:ProtectStructure + ss:ProtectWindowsFalse/ss:ProtectWindows + /ss:ExcelWorkbook + ss:Styles + ss:Style ss:ID=Default + ss:Alignment ss:Vertical=Top / + ss:Font ss:FontName=arial ss:Size=10 / + ss:Borders + ss:Border ss:Weight=1 ss:LineStyle=Continuous ss:Position=Top / + ss:Border ss:Weight=1 ss:LineStyle=Continuous ss:Position=Bottom / + ss:Border ss:Weight=1 ss:LineStyle=Continuous ss:Position=Left / + ss:Border ss:Weight=1 ss:LineStyle=Continuous ss:Position=Right / + /ss:Borders + ss:Interior / + ss:NumberFormat / + ss:Protection / +