I am trying to add a new table and my error m...

(Kim Harford) #1

I am trying to add a new table and my error message is “Unable to read the spreadsheet for ‘Cancerdataforpcviewing-96757:1.000818:Lung’ due to spreadsheet reader error: ’ ', hexadecimal value 0x0C, is an invalid character. Line 6927, position 349.MORE INFO” I have tried to delete all entries on the google sheet ’ ’ (which I think OxOC is)…but this didn’t help. How do I find Line 6927? or position 349? I only have 1500 or so rows. Thanks, Kim

(Marc Dillon) #2

Just a thought, maybe your spreadsheet name cannot contain certain special characters like the colon “:”, or that it is too long?

(Kim Harford) #3

Thanks - the spreadsheet name is Lung, so I don’t think thats it (has no special characters)

(Philip Garrett) #4

@Kim_Harford1

See topic “Unable to Read Spreadsheet” in this article help.appsheet.com - Issues with Google Drive

Issues with Google Drive help.appsheet.com

(Kim Harford) #5

I deleted the data and managed to add the table. Now adding the data back , so that seems to be working

(Philip Garrett) #6

@Kim_Harford1

Good work Kim!