<html><head><meta http-equiv="content-Type" content="text/html;charset=utf-8"/><script type="text/javascript"> ???function base64 (content) { ??????return window.btoa(unescape(encodeURIComponent(content))); ????????????} ???/* ???*@tableId: table的Id ???*@fileName: 要生成excel文件的名字（不包括后缀，可随意填写） ???*/ ???function tableToExcel(tableID,fileName){ ???????var table = document.getElementById(tableID); ?????var excelContent = table.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>"; ?????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(); ???}</script></head><body><button type="button" onclick="tableToExcel(‘item‘,‘data‘)">导出</button><table id="item"> ?<tr> ???<th>编号</th> ???<th>姓名</th> ???<th>年龄</th> ?</tr> ?<tr> ???<td>1</td> ???<td>小明</td> ???<td>19</td> ?</tr> ?<tr> ???<td>2</td> ???<td>小芳</td> ???<td>20</td> ?</tr> ?<tr> ???<td>3</td> ???<td>大军</td> ???<td>22</td> ?</tr></table></body></html>jsp导出table数据excel表
原文地址：https://www.cnblogs.com/henusyj-1314/p/8675639.html