詳細說明請閱讀: 純前端利用 js-xlsx實作 Excel 檔案導入導出功能(1)
導入功能實作
官方示例: http://oss.sheetjs.com/js-xlsx/
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="http://oss.sheetjs.com/js-xlsx/xlsx.full.min.js"></script>
</head>
<body>
<input type="file" onchange="importf(this)" />
<div id="demo"></div>
<script>
var rABS = false; //是否将檔案讀取為二進制字元串
function importf(obj) {//導入
if (!obj.files) { return; }
var f = obj.files[0];
{
var reader = new FileReader();
var name = f.name;
reader.onload = function (e) {
var data = e.target.result;
var wb;
if (rABS) {
wb = XLSX.read(data, { type: 'binary' });
} else {
var arr = fixdata(data);
wb = XLSX.read(btoa(arr), { type: 'base64' });
}
document.getElementById("demo").innerHTML = JSON.stringify(XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]));
};
if (rABS) reader.readAsBinaryString(f);
else reader.readAsArrayBuffer(f);
}
}
function fixdata(data) {
var o = "", l = 0, w = 10240;
for (; l < data.byteLength / w; ++l) o += String.fromCharCode.apply(null, new Uint8Array(data.slice(l * w, l * w + w)));
o += String.fromCharCode.apply(null, new Uint8Array(data.slice(l * w)));
return o;
}
</script>
</body>
</html>
2.導出功能的實作
注意:導出其他格式檔案可能會出現亂碼問題,如有好的解決方案請留言
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<button onclick="downloadExl(jsono)">導出</button>
<script src="http://oss.sheetjs.com/js-xlsx/xlsx.full.min.js"></script>
<!--調用FileSaver saveAs函數可以實作檔案下載下傳-->
<!--<script src="http://sheetjs.com/demos/Blob.js"></script>
<script src="http://sheetjs.com/demos/FileSaver.js"></script>-->
<script>
//如果使用 FileSaver.js 就不要同時使用以下函數
function saveAs(obj, fileName) {//當然可以自定義簡單的下載下傳檔案實作方式
var tmpa = document.createElement("a");
tmpa.download = fileName || "下載下傳";
tmpa.href = URL.createObjectURL(obj); //綁定a标簽
tmpa.click(); //模拟點選實作下載下傳
setTimeout(function () { //延時釋放
URL.revokeObjectURL(obj); //用URL.revokeObjectURL()來釋放這個object URL
}, 100);
}
var jsono = [{ //測試資料
"保存期限臨期預警(天)": "adventLifecycle",
"商品标題": "title",
"建議零售價": "defaultPrice",
"高(cm)": "height",
"商品描述": "Description",
"保存期限禁售(天)": "lockupLifecycle",
"商品名稱": "skuName",
"商品簡介": "brief",
"寬(cm)": "width",
"阿達": "asdz",
"貨号": "goodsNo",
"商品條碼": "skuNo",
"商品品牌": "brand",
"淨容積(cm^3)": "netVolume",
"是否保存期限管理": "isShelfLifeMgmt",
"是否串号管理": "isSNMgmt",
"商品顔色": "color",
"尺碼": "size",
"是否批次管理": "isBatchMgmt",
"商品編号": "skuCode",
"商品簡稱": "shortName",
"毛重(g)": "grossWeight",
"長(cm)": "length",
"英文名稱": "englishName",
"淨重(g)": "netWeight",
"商品分類": "categoryId",
"這裡超過了": 1111.0,
"保存期限(天)": "expDate"
}];
const wopts = { bookType: 'xlsx', bookSST: false, type: 'binary' };//這裡的資料是用來定義導出的格式類型
// const wopts = { bookType: 'csv', bookSST: false, type: 'binary' };//ods格式
// const wopts = { bookType: 'ods', bookSST: false, type: 'binary' };//ods格式
// const wopts = { bookType: 'xlsb', bookSST: false, type: 'binary' };//xlsb格式
// const wopts = { bookType: 'fods', bookSST: false, type: 'binary' };//fods格式
// const wopts = { bookType: 'biff2', bookSST: false, type: 'binary' };//xls格式
function downloadExl(data, type) {
const wb = { SheetNames: ['Sheet1'], Sheets: {}, Props: {} };
wb.Sheets['Sheet1'] = XLSX.utils.json_to_sheet(data);//通過json_to_sheet轉成單頁(Sheet)資料
saveAs(new Blob([s2ab(XLSX.write(wb, wopts))], { type: "application/octet-stream" }), "這裡是下載下傳的檔案名" + '.' + (wopts.bookType=="biff2"?"xls":wopts.bookType));
}
function s2ab(s) {
if (typeof ArrayBuffer !== 'undefined') {
var buf = new ArrayBuffer(s.length);
var view = new Uint8Array(buf);
for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
return buf;
} else {
var buf = new Array(s.length);
for (var i = 0; i != s.length; ++i) buf[i] = s.charCodeAt(i) & 0xFF;
return buf;
}
}
</script>
</body>
</html>
![一位經驗豐富的前端開發人員因未能通過算法面試題而受人嘲笑[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)