关于表格导出

1：静态页面

 <table id='partnerlistall' class="table table-hover table-striped table-bordered table-advanced tablesorter" style="display:none;position:absolute;left:-99999999px;margin-top: 10px" >
                                <thead>
                                    <tr class="topnav">
                                        <th>序号</th>
                                        <th>ID</th>
                                        <th>微信昵称</th>
                                        <th>姓名</th>
                                        <th>性别</th>
                                        <th>手机号</th>
                                        <th>等级名称</th>
                                        <th>推荐人/推荐人ID</th>
                                        <th>加入时间</th>
                                        <th>所属区域</th>
                                        <th>状态</th>
                                    </tr>
                                </thead>
                                <tbody id="education-news-data2"> </tbody>
</table>

2：js

//把数据渲染到education-news-data2里面
var dataParam1 = {
			page: 1,
			rows: 999,
		}

		$('#user_id').val() && (dataParam1.user = $('#user_id').val())
		$('#up_user_id').val() && (dataParam1.up_user = $('#up_user_id').val())
		$('#user_type').val() && (dataParam1.level_no = $('#level-name').find('option:selected').attr('data-level_no'))
		$('#user_type').val() && (dataParam1.classify_id = $('#user_type').val())

		$.ajax({
			url: interface_url + "filter/queryDistributorPageByCnd.do",
			type: 'post',
			dataType: 'json',
			data: JSON.stringify(dataParam1),
			contentType: 'application/json;charset=UTF-8',
			success: function (data) {
				console.log('导出的数据')
				console.log(data)
				if (data.retCode === 0) {
					renderTable1(data.data.list)
				} else {
					toastr.error(data.message);
				}
			},
			error: function () {
			}
		});

function renderTable1(list) {
		var str = ''
		var arr_name = ""
		$.each(list.list, function (index, obj) {
			var areaStr = ''
			console.log(obj)
			$.each(obj.areaList, function (index2, obj2) {
				console.log(obj2)
				/*
				var pro_name = obj2.pro_name || '';
				var city_name = obj2.city_name || '';
				var region_name = obj2.region_name || '';
				var str = pro_name == city_name ? pro_name : (pro_name + city_name)
				areaStr += '<p><span>' + (index2 + 1) + '、</span> ' + str + region_name +'</p>'
				*/
				areaStr += '<p><span>' + (index2 + 1) + '、</span> ' + (obj2.pro_name || '') + (obj2.city_name || '') + (obj2.region_name || '') + '</p>'
			})
			str += '<tr data-level_no = "' + obj.level_no + '" data-user_id="' + obj.user_id + '" data-distributor_id="' + obj.distributor_id + '">'
			str += '<td>' + (index + 1) + '</td>'
			str += '<td>' + (obj.user_id || '') + '</td>'
			str += '<td>' + (obj.user_name || '') + '</td>'
			str += '<td>' + (obj.reality_name || '') + '</td>'
			str += '<td>' + obj.sex_str + '</td>'
			str += '<td>' + (obj.user_phone || '') + '</td>'
			str += '<td>' + (obj.level_name || '') + '</td>'
			if (obj.up_user_id && obj.up_user_name) {
				str += '<td>' + (obj.up_user_name + '/' + obj.up_user_id || '') + '</td>'
			} else {
				str += '<td>' + (obj.up_user_name + '&nbsp;' + obj.up_user_id || '') + '</td>'
			}

			str += '<td>' + (obj.create_time || '') + '</td>'
			str += '<td>' + areaStr + '</td>'
			str += '<td>' + obj.status_str + '</td>'
			str += '</tr>'
			return obj;
		});
		if (list.length === 0) str = '<tr><td colspan="10" align="center">空</td></tr>'
		$("#education-news-data2").html(str);
	}

3：最后一步是导出表格了

		var print_page2=1;
		$("#partnerlist").click(function(){
			$("#partnerlistall").table2excel({
				// 不被导出的表格行的CSS class类
				exclude: ".noExl",
				// 导出的Excel文档的名称，（没看到作用）
				name: "Excel Document Name",
				// Excel文件的名称
				filename: "分销合伙人" + print_page2 + "页.xlsx"
			});
		})