TypeError: Cannot read property 'getLastRow' of null (line 291, file "Code")

[shanelcorbett]

Hi,

When I run importOrderData I get this error notification: "TypeError: Cannot read property 'getLastRow' of null (line 291, file "Code")"

This is the full line 291:
lastInsertedRowNumber = sheet.getLastRow()-1; // gotta pick somewhere to start, let's start at the last row number

How do I correct this?

Thanks

[zyphlar]

The error indicates that the variable "sheet" is null so double check that the sheet being attempted to load is properly set.

…

On Thu, Sep 3, 2020, 8:57 PM shanelcorbett ***@***.***> wrote: Hi, When I run importOrderData I get this error notification: "TypeError: Cannot read property 'getLastRow' of null (line 291, file "Code")" This is the full line 291: lastInsertedRowNumber = sheet.getLastRow()-1; // gotta pick somewhere to start, let's start at the last row number How do I correct this? Thanks — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#2>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAL2MUHAOZLN3SUEOXSL2LSEBQSZANCNFSM4QW6T3AQ> .