Comments Marcos started the conversationApril 9, 2021 at 1:32pmI get the error: Error Table in data source has no rows.but the google sheet has rows ...please helpThanks[deleted] repliedApril 9, 2021 at 1:41pmHi MarcosThank you for reaching out to us.This usually happens when the spreadsheet is not structured correctly. You can see an example of the spreadsheet in our documentation.Could you kindly send us the file so we can take a closer look?Marcos repliedApril 9, 2021 at 1:57pmHiThis is the link to the google file:https://docs.google.com/spreadsheets/d/e/2PACX-1vQZRNFr4izP1YCjS6wOySUz4LOKQBr3cYUYv9gbfqijKJJO-s32VYJ6WZi4LMjUDBrmJrxpQG4DHE0n/pubhtml[deleted] repliedApril 12, 2021 at 1:30pmHi MarcosI simply copy pasted the data into this spreadsheet https://docs.google.com/spreadsheets/d/1NuJ1PHK_I8q1njmj5xDxJh1RTVHCuV6xQjS33Uwr6vc/edit?usp=sharing and I could successfully create a table as you can see on the screenshot below. Please try using this sheet and you can rearrange the columns in wpDataTables if needed.Marcos repliedApril 13, 2021 at 4:43pmHiI did as you said and copied the data to a new google sheet and it worked indeed.Do not know what was wrong with the original sheet, but seems to work now.ThanksMarcos[deleted] repliedApril 14, 2021 at 6:46amYou are most welcome If there is anything else we can assist you with please don't hesitate to open a new ticket. Have a wonderful day! Sign in to reply ...
I get the error:
ErrorTable in data source has no rows.
but the google sheet has rows ...
please help
Thanks
Hi Marcos
Thank you for reaching out to us.
This usually happens when the spreadsheet is not structured correctly. You can see an example of the spreadsheet in our documentation.
Could you kindly send us the file so we can take a closer look?
Hi
This is the link to the google file:
https://docs.google.com/spreadsheets/d/e/2PACX-1vQZRNFr4izP1YCjS6wOySUz4LOKQBr3cYUYv9gbfqijKJJO-s32VYJ6WZi4LMjUDBrmJrxpQG4DHE0n/pubhtml
Hi Marcos
I simply copy pasted the data into this spreadsheet
https://docs.google.com/spreadsheets/d/1NuJ1PHK_I8q1njmj5xDxJh1RTVHCuV6xQjS33Uwr6vc/edit?usp=sharing
and I could successfully create a table as you can see on the screenshot below.
Please try using this sheet and you can rearrange the columns in wpDataTables if needed.
Hi
I did as you said and copied the data to a new google sheet and it worked indeed.
Do not know what was wrong with the original sheet, but seems to work now.
Thanks
Marcos
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!