- JSONToExcelConvertor(Forguncy.Page.getCell("json_data").getValue(),"统计明细");
- function JSONToExcelConvertor(JSONData, FileName) {
- //先转化json
- var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
- var excel = '<table>';
- var row = "<tr>";
- //设置表头
- var keys = Object.keys(arrData[0]); // Use arrData instead of JSONData
- keys.forEach(function (item) {
- row += "<td>" + item + '</td>';
- });
- //换行
- excel += row + "</tr>";
- //设置数据
- for (var i = 0; i < arrData.length; i++) {
- var row = "<tr>";
- for (var index in arrData[i]) {
- row += '<td>' + arrData[i][index] + '</td>';
- }
- excel += row + "</tr>";
- }
- excel += "</table>";
- 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 += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
- excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
- excelFile += '; charset=UTF-8">';
- excelFile += "<head>";
- excelFile += "<!--[if gte mso 9]>";
- excelFile += "<xml>";
- 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:ExcelWorksheets>";
- excelFile += "</x:ExcelWorkbook>";
- excelFile += "</xml>";
- excelFile += "<![endif]-->";
- excelFile += "</head>";
- excelFile += "<body>";
- excelFile += excel;
- excelFile += "</body>";
- excelFile += "</html>";
- var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
- var link = document.createElement("a");
- link.href = uri;
- link.style = "visibility:hidden";
- link.download = FileName + ".xls";
- document.body.appendChild(link);
- link.click();
- document.body.removeChild(link);
- }
网上找的一个js案例能导出xls,但导出不了xlsx ，希望有大佬指点一下，查询的数据我直接返回在一个单元格中，单元格取位json_data,然后进行操作的 |
陕公网安备：61019002000258 |
隐私政策 |
网站地图