Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Get one Cell Value from Google Sheets via HTML Javascript
Hi all,
I am trying to get one specific cell from a google sheet for displaying on a website.
What i have found is a lot of examples to create a table in html from a google sheet source, but not how to get f.e. Cell "A4" only.
$.getJSON( "https://spreadsheets.google.com/feeds/cells/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script&callback=?"
function (data) {
//what to put in here??
});
any help appreciated
thanks in advance
I am trying to get one specific cell from a google sheet for displaying on a website.
What i have found is a lot of examples to create a table in html from a google sheet source, but not how to get f.e. Cell "A4" only.
$.getJSON( "https://spreadsheets.google.com/feeds/cells/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script&callback=?"
function (data) {
//what to put in here??
});
any help appreciated
thanks in advance
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Julian, hi
I only have a working example which generates a list:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Title</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
</head>
<body>
<h1>Ranking</h1>
<div id="ranking-list"></div>
</body>
</html>
<script type="text/javascript">
$(document).ready(function
//source file is https://docs.google.com/spreadsheets/d/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc
$(function listBooks() {
$.getJSON( "https://spreadsheets.google.com/feeds/list/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script&callback=?",
function (data) {
$('div#ranking-list').appe
$.each(data.feed.entry, function(i,entry) {
var item = '<span style="display:none">' + entry.id.$t + '</span>';
item += 'erhalten: ' + entry.gsx$erhalten.$t;
$('.items').append('<li>' + item + '</span></li>');
});
});
});
});
</script>
I only have a working example which generates a list:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Title</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
</head>
<body>
<h1>Ranking</h1>
<div id="ranking-list"></div>
</body>
</html>
<script type="text/javascript">
$(document).ready(function
//source file is https://docs.google.com/spreadsheets/d/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc
$(function listBooks() {
$.getJSON( "https://spreadsheets.google.com/feeds/list/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script&callback=?",
function (data) {
$('div#ranking-list').appe
$.each(data.feed.entry, function(i,entry) {
var item = '<span style="display:none">' + entry.id.$t + '</span>';
item += 'erhalten: ' + entry.gsx$erhalten.$t;
$('.items').append('<li>' + item + '</span></li>');
});
});
});
});
</script>
Your getJSON call URL returns
to answer the question we need to see the returned JSON as well.
Invalid parameter value: callback=?
to answer the question we need to see the returned JSON as well.
did you just click on the hyperlink? then yes.
but if you embed the whole html code on a website, it will return a list of 14 rows.
remove the ?callback to get the raw data:
https://spreadsheets.google.com/feeds/list/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script
but if you embed the whole html code on a website, it will return a list of 14 rows.
remove the ?callback to get the raw data:
https://spreadsheets.google.com/feeds/list/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script
Do you mean something like this?
$(function listBooks() {
$.getJSON( "https://spreadsheets.google.com/feeds/list/19weOqnGlADXwhxUUtVnfZYv2uH6UJUeSmV5WQXQ5Ccc/od6/public/values?alt=json-in-script&callback=?",
function (data) {
var a4 = data.feed.entry[3].gsx$spielername.$t;
$('#ranking-list').html('The entry in cell A4 is : ' + a4);
});
});
Premium Content
You need an Expert Office subscription to comment.Start Free Trial