<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!--<meta name="renderer" content="webkit" />
<meta http-equiv="X-UA-Compatible" content="IE=webkit">-->
<title>导出table表格到excel</title>
<style type="text/css">
.table{background-color: transparent;border-collapse: collapse;border-spacing: 0;border: 1px solid #ddd;}
.tableStyles{font-size: 12px;margin-bottom: 10px;}
.tableStyles>thead{background-color: #f4f4f4;}
.tableStyles>thead>tr>td,.table-bordered>thead>tr>th{border-bottom-width: 1px;}
.tableStyles>thead>tr>th,.tableStyles>tbody>tr>td{padding: 5px;line-height: normal;text-align: center;vertical-align: middle;color: #999;box-sizing: border-box;border: 1px solid #e6e6e6;}
.tableStyles>tbody>tr{height: 68px;}
.tableStyles>tbody>tr>td{color: #333;}
.tableStyles>tbody>tr:hover{background-color: rgba(227,233,239,.5); }
.tableStyles>tbody>tr>td:hover{background: #6AACF1;color: #fff!important; font-size: 12px; box-sizing: border-box; border: none;padding: 0;cursor: pointer;}
.tableStyles>tbody>tr>td:hover .color11,.tableStyles>tbody>tr>td:hover .color21{color: #fff;}
</style>
</head>
<body>
<table class="table tableStyles" id="tables">
<caption>不正经的统计表</caption><!--可以生成表格的标题-->
<thead>
<tr>
<th>品牌</th>
<th>门店</th>
<th>本周回访</th>
<th>本月回访</th>
<th>总回访</th>
<th>本周成交数</th>
<th>本月成交数</th>
<th>总成交数</th>
<th>异常量</th>
<th>成交转化率</th>
<th>经手人/th>
</tr>
</thead>
<tbody>
<tr>
<td rowspan="3">华为</td>
<td>华为深圳店</td>
<td>20</td>
<td>80</td>
<td>500</td>
<td>1</td>
<td>3</td>
<td>20</td>
<td>1</td>
<td>4.0%</td>
<td>黄生</td>
</tr>
<tr>
<td>华为东莞店</td>
<td>20</td>
<td>80</td>
<td>500</td>
<td>1</td>
<td>3</td>
<td>20</td>
<td>1</td>
<td>4.0%</td>
<td>黄生</td>
</tr>
<tr>
<td>华为佛山店</td>
<td>20</td>
<td>80</td>
<td>500</td>
<td>1</td>
<td>3</td>
<td>20</td>
<td>1</td>
<td>4.0%</td>
<td>黄生</td>
</tr>
<tr>
<td rowspan="3">小米</td>
<td>米家深圳店</td>
<td>20</td>
<td>80</td>
<td>500</td>
<td>1</td>
<td>3</td>
<td>20</td>
<td>1</td>
<td>4.0%</td>
<td>林生</td>
</tr>
</tbody>
</table>
<h3>使用js导出表格到excel</h3>
<p>1.只在谷歌/火狐下起作用,保留单元格合并的效果,下载之后的命名是:下载.xls</p>
<a id="dlink" style="display:none;"></a>
<input type="button" οnclick="tableToExcel('tables', 'name', 'myfile.xls')" value="Export to Excel">
<script type="text/javascript">
var tableToExcel = (function () {
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"><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>{table}</table></body></html>
html将table表中的内容导出为excel文件
最新推荐文章于 2023-02-07 15:58:10 发布