json数据导出excel,兼容IE_jsonfield大小写兼容资源-CSDN文库

共4个文件

html：2个

js：2个

json

兼容IE

兼容office

导出excel

需积分: 41 176 浏览量 2019-01-31 14:03:30 上传评论收藏 323KB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

json数据导出excel.zip （4个子文件）

json数据导出excel

json导出excel .html 1KB

xlsx.full.min.js 900KB

myExcel.js 2KB

表格导出excel.html 2KB

<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>导出例子兼容IE-多页导出</title> </head> <body> <script type="text/javascript" src="./js/xlsx.full.min.js"></script> <div id="container" ></div> <p id="xportxlsx" class="xport"><input type="submit" value="导出" onclick="doit('xlsx');"></p> <p id="xlsxbtn" class="btn"></p> <script type="text/javascript"> /* initial table */ function tc_data(){ var aoa = [ ["This","is","a","Test"], [1,7, 8,9], ["Click","to","edit","cells"] ]; var aoa2 = [ ["This","is","a","Test"], [7,7, 9,9], ["llc","to","edit","s"] ]; //多页导出数据 var data1228 = []; data1228.push(aoa); data1228.push(aoa2); var html1228 = ""; for(var i in data1228){ var ws = XLSX.utils.aoa_to_sheet(data1228[i]); var html_string = XLSX.utils.sheet_to_html(ws, { id: "data-table"+i, editable: true }); html1228 += html_string; } document.getElementById("container").innerHTML = html1228; } </script> <script> function doit(type, fn, dl) { var SheetNames = ["sheet0","sheet1"]; var elt = document.getElementById('data-table0'); var wb = XLSX.utils.table_to_book(elt, {sheet:"sheet0"}); wb["SheetNames"] = SheetNames; for(var i = 1; i< SheetNames.length;i++){ var elt2 = document.getElementById('data-table'+i); var wb2 = XLSX.utils.table_to_book(elt2, {sheet:"sheet"+i}); wb["Sheets"]["sheet"+i] = wb2["Sheets"]["sheet"+i];; }; console.log(wb); return dl ? XLSX.write(wb, {bookType:type, bookSST:true, type: 'base64'}) : XLSX.writeFile(wb, fn || ('test.' + (type || 'xlsx'))); } </script> <script type="text/javascript"> function tableau(pid, iid, fmt, ofile) { tc_data(); if(typeof Downloadify !== 'undefined') Downloadify.create(pid,{ swf: 'downloadify.swf', downloadImage: 'download.png', width: 100, height: 30, filename: ofile, data: function() { return doit(fmt, ofile, true); }, transparent: false, append: false, dataType: 'base64', onComplete: function(){ alert('Your File Has Been Saved!'); }, onCancel: function(){ alert('You have cancelled the saving of this file.'); }, onError: function(){ alert('You must put something in the File Contents or there will be nothing to save!'); } }); else document.getElementById(pid).innerHTML = ""; } tableau('xlsxbtn', 'xportxlsx', 'xlsx', 'test.xlsx'); </script> </body></html>

评论收藏

内容反馈