WEB前端使用SheetJS读写excel文件

SheetJS github官网

引入

<script lang="javascript" src="dist/slim.min.js"></script>
<script lang="javascript" src="dist/xlsx.full.min.js"></script>

读

const reader = new FileReader();
reader.onload = function (e) {
    const data = XLSX.read(e.target.result, {
        type: 'binary'
    });
    const jsonData = {};
    // 遍历处理多个sheet
    if (data.SheetNames && data.SheetNames.length > 0) {
        for (let i = 0; i < data.SheetNames.length; i++) {
            const sheetName = data.SheetNames[i],
            	// 将数据转为json对象，第一行会自动识别为列名
                sheetJson = XLSX.utils.sheet_to_json(data.Sheets[sheetName]);
            jsonData[sheetName] = sheetJson;
        }
    }
}
reader.readAsBinaryString(file);

写

// 将数据转换为sheet结构
const data = [{columnName1:'value11',columnName2:'value12'},{columnName1:'value21',columnName2:'value22'}];
const sheet = XLSX.utils.json_to_sheet(data);
// 构造workbook结构
const workbook = {SheetNames: ['sheet1'], Sheets: {sheet1: sheet}};
// 下载文件
XLSX.writeFile(workbook, 'excel.xlsx');