JavaScript excel导入

以下示例是基于koa+typescript的

import XLSX from 'xlsx';
import fs from 'fs';
import path from 'path';
export = {
   import: async (ctx, next) => {
     	let file = ctx.req.file.filename;
      let { projectCode } = ctx.req.body;
      const xlsxFile = path.resolve('./public', file);
      async function readExcel() {
        return new Promise((resolve, reject) => {
          // read file
          let rawfile = fs.readFileSync(xlsxFile);
          file = XLSX.read(rawfile);
          // get json array
          let j_data = XLSX.utils.sheet_to_json(file.Sheets[file.SheetNames[0]]);
          // 移除自己添加的中文解释
          j_data.shift();
          resolve(j_data);
        });
      }
      let data: any = await readExcel();
   }
}