一个不错的能将HTML表格导出为excel,pdf等的jquery插件

发现一个老外写的不错的jquery插件,可以实现将HTML

表格导出为excel,pdf等格式,

地址在:

https://github.com/kayalshri/

下面看个例子,实现导出表格到excel,pdf

<html>
			<head>
				<title>Export html table to excel and csv using jquery</title>
			<script src="/jquery-1.9.1.min.js"></script>
			<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">
				<script type="text/javascript" src="/jquery.base64.js"></script>

				<script type="text/javascript" src=/tableExport.js"></script>
             
                     <script type="text/javascript" src="/jspdf/libs/sprintf.js">
                      </script>
                   
					    <script type="text/javascript" src="http://localhost:8082/myphp/tableExport.jquery.plugin-master/jspdf/jspdf.js"></script>
						 <script type="text/javascript" src="/jspdf/base64.js"></script>
					  
			</head>
			<body>
				[align=right]
					<br><br><br>			
					<button class="btn btn-success" onClick ="$('#customers').tableExport({type: 'excel', escape: 'false'});">Excel Export</button>
					<button class="btn btn-success" onClick ="$('#customers').tableExport({type: 'pdf', escape: 'false'});">CSV Export</button>
					<br><br>
					[/align]
					<table id="customers" class="table table-striped table-bordered" >
						<thead>			
							<tr class='warning'>
								<th>Country</th>
								<th>Population</th>
								<th>Date</th>
							</tr>
						</thead>
						<tbody>
							<tr>
								<td>Chinna</td>
								<td>1,363,480,000</td>
								<td>March 24, 2014</td>
							</tr>
							<tr>
								<td>India</td>
								<td>1,241,900,000</td>
								<td>March 24, 2014</td>
							</tr>
							<tr>
								<td>United States</td>
								<td>317,746,000</td>
								<td>March 24, 2014</td>
							</tr>
							<tr>
								<td>Indonesia</td>
								<td>249,866,000</td>
								<td>July 1, 2013</td>
							</tr>
							<tr>
								<td>Brazil</td>
								<td>201,032,714</td>
								<td>July 1, 2013</td>
							</tr>
						</tbody>
					</table> 
				</div>
			</body>
		</html>

其实生成PDF,EXCEL的原理,始终就是利用data:application/vnd.ms等去生成的,利用了base64,具体代码可以参考github上代码拿来看看,对于处理简单的EXCEL,PDF导出,足够用了

相关推荐