table 转 excel 无插件

最新推荐文章于 2023-06-28 14:59:43 发布

光影Light

最新推荐文章于 2023-06-28 14:59:43 发布

阅读量413

点赞数 1

分类专栏： javaScript 文章标签： html excel

本文链接：https://blog.csdn.net/qq_33584294/article/details/103276180

版权

javaScript 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


function base64(content) {
		return window.btoa(unescape(encodeURIComponent(content)));
}

function tableToExcel(tableID, fileName) {
	var excelContent = $("#" + tableID).html();
	var excelFile = "<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'>";
	excelFile += "<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>";
	excelFile += "<body><table width='10%'  border='1'>";
	excelFile += excelContent;
	excelFile += "</table></body>";
	excelFile += "</html>";
	var link = "data:application/vnd.ms-excel;base64," + base64(excelFile);
	var a = document.createElement("a");
	a.download = fileName + ".xls";
	a.href = link;
	a.click();
}

html代码

<table class="table report-table" style="margin-top: 20px;" border=1 id = "tableExcel">
	<thead>
	<tr>
		<td class="text-center" style="background-color: #f9fafe;">公证员</td>
		<td class="text-center" style="background-color: #f9fafe;">助手</td>
		<td class="text-center" style="background-color: #f9fafe;">年度</td>
		<td class="text-center" style="background-color: #f9fafe;">类别</td>
		
		<td class="text-center" style="background-color: #f9fafe;">证号</td>
		<td class="text-center" style="background-color: #f9fafe;">当事人</td>
		<td class="text-center" style="background-color: #f9fafe;">受理时间</td>
		<td class="text-center" style="background-color: #f9fafe;">审批时间</td>
		
	</tr>
	</thead>
	<tbody>
	<%
		for (Map<String, Object> data : dataList) {
	%>
	<tr>
		<td class="text-center"><%=data.get("notryName")%></td>
		<td class="text-center"><%=data.get("assistantName")%></td>
		<td class="text-center"><%=data.get("year")%></td>
		<td class="text-center"><%=data.get("typeName")%></td>
		
		<td class="text-center"><%=data.get("serialNumber")%></td>
		<td class="text-center"><%=data.get("partyName")%></td>
		<td class="text-center"><%=data.get("acceptDate")%></td>
		<td class="text-center"><%=data.get("approveDate")%></td>
	</tr>
	<%
		}
	%>
	</tbody>
</table>

<button class="btn btn-default" onclick="tableToExcel('tableExcel', '未归档明细表（新黄浦）')" title="导出excel">导出excel</button>

纯js实现方式
通过table的Class导出excel
var tableClass = document.getElementsByClassName('ant-table-fixed');
tableClass[0].id = 'tableExcel';
var tableItem = document.getElementById('tableExcel');
var excelContent = tableItem.innerHTML;
var excelFile = "<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'>";
excelFile += "<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>";
excelFile += "<body><table width='10%'  border='1'>";
excelFile += excelContent;
excelFile += "</table></body>";
excelFile += "</html>";
var link = "data:application/vnd.ms-excel;base64," + window.btoa(unescape(encodeURIComponent(excelFile)));
var a = document.createElement("a");
a.download =  "邮费统计.xls";
a.href = link;
a.click();

光影Light

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
3
评论
table 转 excel 无插件

function tableToExcel(tableID, fileName) { var excelContent = $("#" + tableID).html(); var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microso...
复制链接

扫一扫

专栏目录