首页 > 解决方案 > 找不到模块“xlsx”

问题描述

在构建服务器上使用 jenkins 进行构建时得到这个,但我在本地机器上尝试这个然后它工作正常但有错误

15:07:39 "",
15:07:39 "",
15:07:39 "ERROR in src/services/excel.service.ts:2:23 - error TS2307: Cannot find module 'xlsx'.",
15:07:39 "",
15:07:39 "2 import * as XLSX from 'xlsx';",
15:07:39 " ~~~~~~"
15:07:39 

使用 npm install xlsx 安装 xlsx

并导入 xlsx 模块。从'xlsx'导入*作为XLSX;

import { Injectable } from '@angular/core';
import * as XLSX from 'xlsx';
import * as _ from 'lodash';

@Injectable({
  providedIn: 'root'
})
export class ExcelService {

  constructor() { }
  wopts: XLSX.WritingOptions = { bookType: 'xlsx', type: 'array' };
  exportAsExcelFile(json: any, fileName:any): void {
    /* generate worksheet */
    // const ws: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(this.data);
    const ws: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);

    /* generate workbook and add the worksheet */
    const wb: XLSX.WorkBook = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

    /* save to file */
    XLSX.writeFile(wb, fileName);
  }

}

标签: node.jsangulartypescriptnpmsheetjs

解决方案


推荐阅读