js table excel

// 假设有一个id为'myTable'的HTML表格
var wb = XLSX.utils.table_to_book(document.getElementById('myTable'));
var wbout = XLSX.write(wb, {bookType:'xlsx', type:'binary'});
function s2ab(s) {
    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;
}
saveAs(new Blob([s2ab(wbout)],{type:"application/octet-stream"}), '表格.xlsx');

// 使用FileReader API读取上传的Excel文件
var reader = new FileReader();
reader.onload = function(e) {
    var data = e.target.result;
    var workbook = XLSX.read(data, {type: 'binary'});
    var firstSheetName = workbook.SheetNames[0];
    var worksheet = workbook.Sheets[firstSheetName];
    var htmlStr = XLSX.write(worksheet, {bookType:'html', type:'binary'});
    document.getElementById('myTable').innerHTML = htmlStr;
};
reader.readAsBinaryString(fileInput.files[0]);