[SOLVED] Angular:Cannot read properties of undefined (reading ‘0’)


This Content is from Stack Overflow. Question asked by Happy

I want to import an excel with this code but I get this error

Angular Ag Grid Excel Import

Cannot read properties of undefined (reading '0')

This File import
Can this type of file be imported?



I read the app.component.ts file it says that I can import 4 columns.


    var columns = {
        'A': '',
        'B': 'Make',
        'C': 'Model',
        'D': 'Price'


The error occurs in this section of the App component code

 populateGrid(file: any) {
    // our data is in the first sheet
    var firstSheetName = file.SheetNames[0];

The SheetNames field is missing in the file argument (=undefined).
Check the type of the accepted object

This Question was asked in StackOverflow by Happy and Answered by VerZsuT It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?