<!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>