Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Exception: The starting row of the range is too small. (line 292, file "Code") #1

Open
justineusebio opened this issue Apr 25, 2020 · 2 comments

Comments

@justineusebio
Copy link

I tried to follow the steps as listed but encountered errors

This line is referenced when running the data import
lastInsertedOrderDate = sheet.getRange(lastInsertedRowNumber, ORDER_DATE_COLUMN_NUMBER).getValue();

This line is referenced when running just the manuallyimportofdata
activeSheet = ss.getActiveSheet();

Unsure how to fix

@nickbollen123
Copy link

I was able to get around this by adding in some content to the first 5 rows manually, and then it was able to run okay

@zyphlar
Copy link
Contributor

zyphlar commented Jun 16, 2020

Correct I apologize, we've always had some preexisting data in our sheets so it's hard to test. If there's a bugfix you're aware of to allow entered data to begin on row 2 (after row 1 headers) I'm happy to modify. Here are the headers we use for example.

Imported Data | Attendee Name | Purchased | Class Date | Order placed on | Qty | Unit Price | Phone | E-mail | Additional Info | Member? | Date | DateNum | Class Identifier

I've also updated the Readme to include the fact that either a header row is needed or you need to uncomment line 293-294 in the source to auto-fill Row 1.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants