<a name=“excelExport” id=“excelExport” οnclick=“toExcel()”; style=“color: #224dea;text-decoration: none;
font-size: 16px;margin-left: 278px; margin-top: 24px;display: block;
cursor: pointer;float: right”>导出 Excel
<div class="sheet_box">
<table id="selfGrade" cellspacing="0" align="center" border="2px" style="width: 522px;">
<thead class="sheet_tit">
<tr >
<th width="100px">名次</th>
<th width="130px">姓名</th>
<th width="130px">分数</th>
<th width="130px">所属班级</th>
</tr>
</thead>
<tbody align="center"></tbody>
</table>
</div>
/*个人成绩排名*/
$(function (){
$.ajax({
type: "get",
dataType: "json",
async: false, //同步
url: '' ,//数据接口
data: {},
success: function (data) {
var str = "";
var json = eval(data.data);
$.each(json, function (index) {
console.log("2222"+JSON.stringify(json))
//循环获取数据
str += '<tr>' +
'<td>' + json[index].rank + '</td>' +
'<td>' + json[index].studentname+ '</td>' +
'<td>' + json[index].score + '</td>' +
'<td>' + json[index].classname + '</td>' +
'</tr>';
});
$("#selfGrade tbody").prepend(str);
},
error: function (data) {
//alert(222)
}
});
});
//导出excel
function toExcel(){
//获取表格
var exportFileContent = document.getElementById("selfGrade").outerHTML;
//使用Blob
var blob = new Blob([exportFileContent], {type: "text/plain;charset=utf-8"}); //解决中文乱码问题
blob = new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type});
//设置链接
var link = window.URL.createObjectURL(blob);
var a = document.createElement("a"); //创建a标签
a.download = "个人成绩排名.xls"; //设置被下载的超链接目标(文件名)
a.href = link; //设置a标签的链接
document.body.appendChild(a); //a标签添加到页面
a.click(); //设置a标签触发单击事件
document.body.removeChild(a); //移除a标签
}