jsp页面下载数据至excel,具体代码如下:
<%
String exportToExcel = request.getParameter("exportToExcel");
if (exportToExcel != null && exportToExcel.toString().equalsIgnoreCase("YES")) {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "inline; filename=" + "excel.xls");
}
%>
其余页面内容再不粘贴,还有一个超链接点击导出按纽
<%
if (exportToExcel == null) {
%>
导出表格
<%
}
%>
运行能导出当前页面所有内容,table内容有,其他的内容也都导出了,查了一下好像是直接将页面数据流导出了,现在我只想导出table里面的数据,具体该在哪里添加怎样的判断语句?请帮忙,也可私信,有报酬。
用js导出
<script>
function base64 (content) {
return window.btoa(unescape(encodeURIComponent(content)));
}
function exportExcel() {
var table = $("#所需要导出的元素id");
var excelContent = table[0].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 = "报价明细.xlsx";
a.href = link;
a.click();
}
</script>
<div style="margin: 10px 0; float: right;"><input class="btn btn-primary" type='button' onclick="exportExcel()" value="导出分析结果"/></div>
代码运用错误