Cannot find module 'xlsx'

Question

Am getting this while making build using jenkins on build server but i am trying this on local machine then it working fine with error

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

install xlsx using npm install xlsx

And import xlsx module. import * as XLSX from '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);
  }

}

Did you import your service in app.module.ts and add it in the providers too? — yazan, Nov 17 '20 at 11:34
`install xlsx using npm install xlsx` - did you save your module? `npm install xlsx --save` — jeeves, Nov 17 '20 at 11:41
@yazan why you need and what you want to know in app.module.ts — harkesh kumar, Nov 17 '20 at 11:48

score 6 · Accepted Answer · answered Oct 18 '22 at 16:46

6

import xlsx from 'xlsx/xlsx';

This line works for me on node/typescript environment.

answered Oct 18 '22 at 16:46

Luis Barrientos Fajardo

411
5
4

score 2 · Answer 2 · edited Jan 27 '23 at 16:11

2

I resolved the error by this line:

import * as XLSX from "xlsx/xlsx";

edited Jan 27 '23 at 16:11

Tyler2P

2,324
26
22
31

answered Jan 25 '23 at 06:28

akshat chawla

39
8

Bill · Answer 3 · 2023-01-06T21:06:31.973

1

I got the same error message. I was running xlsx 18.5, so I removed it and reloaded 17.1 and everything works fine now with a standard

import XLSX from 'xlsx'

No particular reason for 17.1 except it was working fine in another app and I wanted to remove that as a possibility.

edited Jan 06 '23 at 21:06

answered Jan 06 '23 at 20:40

Bill

1,423
2
27
51

Cannot find module 'xlsx'

3 Answers3