Hello good evening.I have been trying to build an app from an excel workbook with numerous spread sheets. Appsheet however only loads the first sheet and with the title of the workbook. When i try to load the other worksheets using the 'New table", and select get data from google, it sends me to the workbook but does not allow me to select and add more sheets. The feedback i get is โsorry we were not able to connect to that sourceโ Please how do i solve this?
Hi Nana! Welcome to the AppSheet Community!!
The Excel workbook you are trying to connect to, is it owned by you? Or just shared to you?
Can you use Google sheets at all?
Yes the sheet is owned by me. Yes I can use Google sheets.
What I meant is if you could use a Google sheet instead of the Excel sheet? I wasnโt very clear in that.
The rationale is that Excel in AppSheet is still very โyoungโ and there are some known issues/kinks they are still working out. Donโt get me wrong. Many people are using Excel successfully. But if you have the option, I would go with a Google sheet as they integrate much more smoothly.
I understand my comments above may not be helping you.
I have tried creating a test app from an Excel sheet I had just โlaying aroundโ. I am getting the same error message as you - โsorry we were not able to connect to that sourceโ.
Iโm checking to see if I can get around it.
In the meantime, I donโt think this should be happening and I would recommend that you contact support@appsheet.com
Noted. Thank you very much. I will contact them. Thanks.
So I have not found a way around the error unless the Excel workbook is saved as a Google sheet.
Thanks. I have done that and it worked. I have been ableto add the tables from Google sheet. Thank you.
I was able to do that if sheet is connected with โone driveโ instead of โgoogle driveโ.
Hi Nana,
I have confirmed that you have uncovered a bug that was just introduced recently.
It should definitely be possible to store an Excel workbook on Google drive that contains two or more worksheets. You should then be able to add these worksheets as AppSheet tables.
We have fixed the problem.
If testing goes well, the change will be released on Tuesday afternoon April 14, 2020.
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |