JS导出CSV文件

最新推荐文章于 2024-05-26 00:15:00 发布

向夏"

最新推荐文章于 2024-05-26 00:15:00 发布

阅读量4.6k

点赞数

分类专栏： JS 文章标签： JS导出文件

本文链接：https://blog.csdn.net/xiangxixia/article/details/86605617

版权

JS 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

JS通过table的id将数据导出为csv文件格式

<a class="btn" id="productqueryOutXls" target="">导出</a>
		<table class="" id="alternatecolor">
			<thead>
			<tr>
				<th>订单号</th>
				<th>订单时间</th>
				<th>订单状态</th>
				<th>订单金额</th>
				<th>支付方式</th>
			</tr>
			</thead>
			<tbody>
					<tr>
						<td>1234567</td>
						<td>2019-01-23 01:30:09</td>
						<td>complete</td>
						<td>$25.05</td>
						<td>paypal</td>
					</tr>
			</tbody>
		</table>



<script>
        $(document).on("click", "#productqueryOutXls", function () {
            var $trs = $("#alternatecolor").find("tr");
            var str = "";
            for (var i = 0; i < $trs.length; i++) {
                var $tds = $trs.eq(i).find("td,th");
                for (var j = 0; j < $tds.length; j++) {
                    str += $tds.eq(j).text() + ",";
                }
                str += "\n";
            }

            var aaaa = "data:text/csv;charset=utf-8,\ufeff" + str;
            var link = document.createElement("a");
            link.setAttribute("href", aaaa);
            var date=new Date().getTime();
            var filename = new Date(date).toLocaleDateString();
            link.setAttribute("download", filename + ".csv");
            link.click();
        });
	</script>