EasyUI datagrid 前端Execl导出

前端导出共用方法

easyuiDGExportExcel : function(opts){
        $.toast({

function easyuiDGExportExcel(opts){
    	$.toast({
			icon : 'info',
			text: '数据生成中，请稍等...'
		});
    	
        $.ajax({
            url: opts.dataUrl,
            data: "queryParams="+encodeURIComponent(JSON.stringify(opts.params)) +"&paging=false&page=0",
            async: true,
            type: "POST",
            success: function (result) {
                if (result.data.length > 0) {
                	var tableCodes = ['<table border="1" rull="all" style="border-collapse:collapse">'];
                	var trStyle = 'height:32px';
                    var tdStyle0 = 'vertical-align:middle;padding:0 4px';
                	
                    var rowIndex = 0;
                	$(opts.columns).each(function () {
                		var row = this;
                		tableCodes.push('<tr style="'+trStyle+'">');
                		if (opts.rownum && rowIndex == 0) {
                			tableCodes.push('<th rowspan="'+opts.columns.length+'" style="'+tdStyle0+';width:50px;">序号</th>');
                		}
                		$(row).each(function(){
                			var col = this;
                			if (!col.hidden) {
                				var tdStyle = tdStyle0 + ';';
                				if (col.width) {
                					tdStyle += "width:" + col.width + "px;";
                				}
                				if (col.align) {
                					tdStyle += "text-align:" + col.align + ";";
                				}
                				tableCodes.push('<th style="'+tdStyle+'" rowspan="'+(col.rowspan || 1)+'" colspan="'+(col.colspan || 1)+'">'+col.title+'</th>');
                			}
                		})
                		tableCodes.push('</tr>');
                		rowIndex ++;
                    });
                	
                    $(result.data).each(function (rowIndex) {
                        var rowData = this;
                        tableCodes.push('<tr style="'+trStyle+'">');
                        if (opts.rownum) {
                        	tableCodes.push('<td style="'+tdStyle0+'">'+(rowIndex + 1)+'</td>');
                        }
                        
                        $(opts.columns).each(function () {
                        	var row = this;
                        	$(row).each(function(){
                        		var col = this;
                        		if($.isEmpty(col.colspan) || col.colspan <= 1){
	                        		var showVal = "";
	                        		if (!col.hidden) {
	                        			if (col.formatter) {
	                        				showVal = col.formatter(rowData[col.field], rowData, rowIndex);
	                        				// 图片标签格式化成图片title
	                        				var imgStrs = (showVal+"").match(/<img[^>]+>/g);
	                        				if($.isNotEmpty(imgStrs)){
	                        					var p1 =/title=[\"|'](.*?)[\"|']/;
	                        					var title = "&nbsp;",temp;
	                        					$.each(imgStrs,function(i,ele){
	                        						temp = ele.match(p1);
	                        						if($.isNotEmpty(temp)){
	                        							title = temp[1];
	                        						}
	                        						showVal = showVal.replace(ele, title);
	                        					})
	                        				}
	                        			} else {
	                        				showVal = rowData[col.field];
	                        			}
	                        			if(null == showVal)
	                        				showVal = "&nbsp;";
	                        			
	                        			tableCodes.push('<td style="'+tdStyle0+'">'+showVal+'</td>');
	                    			}
                        		}
                        	});
                        });
                        
                        tableCodes.push('</tr>');
                    })
                    tableCodes.push('</table>');
                    
                    var uri = 'data:application/vnd.ms-excel;base64,'
                        , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body>{table}</body></html>'
                        , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }
                        , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
                        
                    var ctx = { worksheet: 'Worksheet', table: tableCodes.join('') };
                    var data = base64(format(template, ctx));
                    var filename = opts.fileName+"导出"; 
                    if (window.navigator.msSaveBlob){
                        var blob = $.b64toBlob(data);
                        window.navigator.msSaveBlob(blob, filename);
                    } else {
                        var alink = $('<a style="display:none"></a>').appendTo('body');
                        alink[0].href = uri + data;
                        alink[0].download = filename;
                        alink[0].click();
                        alink.remove();
                        
                        $.toast({
            				icon : 'success',
            				text : '导出记录成功'
            			})
                    }
                	
                } else {
                	$.toast({
        				icon : 'warning',
        				text : '没有符合条件的记录'
        			})
                }
            }
        });
    }
    
    function b64toBlob(data){
        var sliceSize = 512;
        var chars = atob(data);
        var byteArrays = [];
        for(var offset=0; offset<chars.length; offset+=sliceSize){
            var slice = chars.slice(offset, offset+sliceSize);
            var byteNumbers = new Array(slice.length);
            for(var i=0; i<slice.length; i++){
                byteNumbers[i] = slice.charCodeAt(i);
            }
            var byteArray = new Uint8Array(byteNumbers);
            byteArrays.push(byteArray);
        }
        return new Blob(byteArrays, {
            type: ''
        });
    }

此处的dataUrl通过后台请求，返回json数据，可根据需求改造成直接导入data参数，不走后台请求

支持复杂表头导出, 公司项目需求简单实现，没详细测试，如发现bug还麻烦告知，继续完善，谢谢

 

部分代码参考其他网友资料，具体出处丢失，如有不妥联系删除！谢谢