NodeJS Excel文件 xls格式转xlsx文件格式

 思路：读取xls文件--》生成xlsx文件

import xlsx from 'xlsx';

/**
 * xls文件转化为xlsx
 * @param filepath
 */
export function transXlsForXLSX(filepath: string){
  const workBook = xlsx.readFile(filepath);
  // console.log(workBook.SheetNames);
  const workbook_save = {
    SheetNames: [],
    Sheets: {},
  };
  for (const sheet of workBook.SheetNames) {
    const objs = xlsx.utils.sheet_to_json(workBook.Sheets[sheet]);
    // console.log(objs);
    workbook_save.SheetNames.push(sheet);
    workbook_save.Sheets[sheet] = xlsx.utils.json_to_sheet(objs);
  }
  const filename = filepath.substring(0, filepath.lastIndexOf('.')) + '.xlsx';
  xlsx.writeFile(workbook_save, filename);
  return filename;
}