Cannot find namespace 'NodeJS'

Question

If i run this code, i get an error, Cannot find namespace 'NodeJS'.

  public exportExcel(jsonData: any[], excelFileName: string): void {
    //Excel Title, Header, Data
    const header: string[] =  Object.keys(jsonData[0]);
    const data = jsonData;

    //Create workbook and worksheet
    let workbook = new Workbook();
    let worksheet = workbook.addWorksheet(excelFileName);

    //Add Header Row
    let headerRow = worksheet.addRow(header);

    // Cell Style : Fill and Border
    headerRow.eachCell((cell, number) => {
      cell.fill = {
        type: 'pattern',
        pattern: 'solid',
        fgColor: { argb: 'FFFFFF00' },
        bgColor: { argb: 'FF0000FF' }
      }
      cell.border = { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' } }
    })
    // Add Data and Conditional Formatting
    data.forEach((element) => {
      let eachRow = [];
      header.forEach((headers) => {
        eachRow.push(element[headers])
      })
      if (element.isDeleted === "Y") {
        let deletedRow = worksheet.addRow(eachRow);
        deletedRow.eachCell((cell, number) => {
          cell.font = { name: 'Calibri', family: 4, size: 11, bold: false, strike: true };
        })
      } else {
        worksheet.addRow(eachRow);
      }
    })

...

ERROR in node_modules/exceljs/index.d.ts(1648,34): error TS2503: Cannot find namespace 'NodeJS'.

@dev but i get this information, what it´s mean? 100 unchanged chunks chunk {main} main.js, main.js.map (main) 429 kB [initial] [rendered] chunk {vendor} vendor.js, vendor.js.map (vendor) 9.43 MB [initial] [rendered] Time: 6775ms — kuku
– kuku, Commented Oct 3, 2019 at 17:27
Not sure about those lines. but did you tried the suggestions mentioined in the above link and did it helped? — Rajat
– Rajat, Commented Oct 3, 2019 at 17:40
Yes i tried and get in the Chrome console this errors: core.js:9110 ERROR Error: Uncaught (in promise): NullInjectorError: StaticInjectorError(AppModule)[EventOverviewPageComponent -> ExportService]: StaticInjectorError(Platform: core)[EventOverviewPageComponent -> ExportService]: NullInjectorError: No provider for ExportService! — kuku
– kuku, Commented Oct 3, 2019 at 17:46

RICHARD ABRAHAM · Accepted Answer · 2020-07-06 15:24:27Z

25

Solution targetting Angular8+ Projects:

This is a known bug, caused due to the incompatibility of exceljs with the version of @types/node. I faced similar issue with Angular 10.

2 possible solutions exists:

Recommended: Update your tsconfig.app.json file with "types": ["node"]

If you are okay without having type support, then you can simply use the below import:
import * as Excel from "exceljs/dist/exceljs.min.js";

answered Jul 6, 2020 at 15:24

RICHARD ABRAHAM

2,58825 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wbartussek Over a year ago

In my case this worked only if applied to tsconfig.app.json in the project root.

user3894404 · Accepted Answer · 2020-03-26 17:06:02Z

3

Just Open index.d.ts file from yours exceljs node_modules

and replace this line dictionary: Buffer | NodeJS.TypedArray | DataView | ArrayBuffer; // deflate/inflate only, empty dictionary by default

with this

dictionary: Buffer | DataView | ArrayBuffer; // deflate/inflate only, empty dictionary by default

and then just ng serve

answered Mar 26, 2020 at 17:06

user3894404

413 bronze badges

2 Comments

Jake Smith Over a year ago

LOL! What about the next time they install their dependencies??? Would you expect them to change the code in their node modules every time?

MCH Over a year ago

you can use package-patch if you HAVE to go with this approach

Collectives™ on Stack Overflow

Cannot find namespace 'NodeJS'

2 Answers 2

Solution targetting Angular8+ Projects:

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Solution targetting Angular8+ Projects:

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related