-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Android Question How to display data from Google spreadsheet?
- Thread starter cenyu
- Start date
- Similar Threads Similar Threads
If you have a spreadsheet in google, the link is something like this one:
https://docs.google.com/spreadsheets/d/1lZDOwszmh0LTv1EiiCkRZQAnrFnpobtaSshmQvgtWbA/edit?usp=sharing
If you want to access it with B4a you can use httputils or OKHTTP (Get or Download Request). The URL should be something like this:
https://spreadsheets.google.com/tq?key=1lZDOwszmh0LTv1EiiCkRZQAnrFnpobtaSshmQvgtWbA
The result will be a json document which you can parse with B4A:
{"version":"0.6","reqId":"0","status":"ok","sig":"941982251","table":{"cols":[{"id":"A","label":"","type":"string"},{"id":"B","label":"","type":"string"}],"rows":[{"c":[{"v":"Type"},{"v":"content"}]},{"c":[{"v":"string"},{"v":"Hello B4A"}]},{"c":[{"v":"name"},{"v":"Stefan"}]}]}}
see http://basic4ppc.com:51042/json/index.html
https://docs.google.com/spreadsheets/d/1lZDOwszmh0LTv1EiiCkRZQAnrFnpobtaSshmQvgtWbA/edit?usp=sharing
If you want to access it with B4a you can use httputils or OKHTTP (Get or Download Request). The URL should be something like this:
https://spreadsheets.google.com/tq?key=1lZDOwszmh0LTv1EiiCkRZQAnrFnpobtaSshmQvgtWbA
The result will be a json document which you can parse with B4A:
{"version":"0.6","reqId":"0","status":"ok","sig":"941982251","table":{"cols":[{"id":"A","label":"","type":"string"},{"id":"B","label":"","type":"string"}],"rows":[{"c":[{"v":"Type"},{"v":"content"}]},{"c":[{"v":"string"},{"v":"Hello B4A"}]},{"c":[{"v":"name"},{"v":"Stefan"}]}]}}
see http://basic4ppc.com:51042/json/index.html
Upvote
0
