node-xlsx将excel转Table

const xlsx = require('node-xlsx')
const fs = require('fs');
const excelFilePath = './menu.xlsx'
const sheets = xlsx.parse(excelFilePath);
const sheet = sheets[0];
 
s = '<table>'
 
sheet.data.forEach((row, index) => {
    if (index < 285) {
        // 数组格式, 根据不同的索引取数据
        s += `
    <tr>
        <td>${row[0] == null ? '' : row[0].trim()}</td>
        <td>${row[1] == null ? '' : row[1].trim()}</td>
        <td>${row[2] == null ? '' : row[2].trim()}</td>
        <td>${row[3] == null ? '' : row[3].trim()}</td>
        <td>${row[4] == null ? '' : row[4].trim()}</td>
        <td>${row[5] == null ? '' : row[5].trim()}</td>
    </tr>`
    }
})
s += '</table>'
fs.writeFile('./table.txt', s, err => {
    console.log(err);
})
// console.log(s);