代码总结
1:文件上传下载的选项卡组件:
//下载
var a = "http://localhost:41168/UpLoad/MeterModel/%E6%B0%B4%E8%A1%A8%E7%82%B9%E8%A1%A8%E6%A8%A1%E6%9D%BF.xls";
var link = document.createElement("a");
link.href = a;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
//打开文件
window.open(a);
根据Json 生成excel文件
前三个都使用过,可行。附上其他博主链接:
https://www.cnblogs.com/lxk233/p/10224164.html
一个excel里生成两个表:
// excelFile += "<x:ExcelWorkbook>";
// excelFile += "<x:ExcelWorksheets>";
// excelFile += "<x:ExcelWorksheet>";
// excelFile += "<x:Name>";
// excelFile += "{Sheet1}";
// excelFile += "</x:Name>";
// excelFile += "<x:WorksheetOptions>";
// excelFile += "<x:DisplayGridlines/>";
// excelFile += "</x:WorksheetOptions>";
// excelFile += "</x:ExcelWorksheet>";
// excelFile += "<x:ExcelWorksheet>";
// excelFile += "<x:Name>";
// excelFile += "{Sheet2}";
// excelFile += "</x:Name>";
// //excelFile += secondtable;
// excelFile += "<x:WorksheetOptions>";
// // excelFile += secondtable;
// excelFile += "<x:DisplayGridlines/>";
// excelFile += "</x:WorksheetOptions>";
// excelFile += "</x:ExcelWorksheet>";
// excelFile += "</x:ExcelWorksheets>";
// excelFile += "</x:ExcelWorkbook>";