![\"\"](\"httpss:\/\/www.powenko.com\/wordpress\/wp-content\/uploads\/2010\/12\/Screen-shot-2010-12-30-at-9.33.50-PM.png\" "\\"Screen")
<\/a><\/div>\n\n\/\/ To see the data that this visualization uses, browse to
\n\/\/ httpss:\/\/spreadsheets.google.com\/ccc?key=pCQbetd-CptGXxxQIG7VFIQ
\nvar\u00a0query\u00a0=\u00a0new\u00a0google.visualization.Query(
\n‘httpss:\/\/spreadsheets.google.com\/tq?key=pCQbetd-CptGXxxQIG7VFIQ&pub=1’);<\/p>\n
\/\/ Apply query language.
\nquery.setQuery(‘SELECT A,D WHERE D > 100 ORDER BY D’);<\/p>\n
\/\/ Send the query with a callback function.
\nquery.send(handleQueryResponse);
\n}<\/p>\n
function\u00a0handleQueryResponse(response)\u00a0{
\nif\u00a0(response.isError())\u00a0{
\nalert(‘Error in query: ‘\u00a0+\u00a0response.getMessage()\u00a0+\u00a0‘ ‘\u00a0+\u00a0response.getDetailedMessage());
\nreturn;
\n}<\/p>\n
var\u00a0data\u00a0=\u00a0response.getDataTable();
\nvisualization\u00a0=\u00a0new\u00a0google.visualization.LineChart(document.getElementById(‘visualization’));
\nvisualization.draw(data,\u00a0{legend:\u00a0‘bottom’});
\n}\u200b<\/p>\n<\/div>\n
google.visualization.Query.setResponse({version:'0.6',status:'ok',sig:'1618897520',table:{cols:[{id:'A',label:'',type:'string',pattern:''},{id:'B',label:'Country code',type:'string',pattern:''},{id:'C',label:'Population',type:'number',pattern:'#0.###############'},{id:'D',label:'Population Density',type:'number',pattern:'#0.###############'},{id:'E',label:'',type:'string',pattern:''}],rows:[{c:[{v:'China'},{v:'CN'},{v:1.32297E9,f:'1322970000'},{v:137.0,f:'137'},{v:''}]},{c:[{v:'India'},{v:'IN'},{v:1.13013E9,f:'1130130000'},{v:336.0,f:'336'},{v:''}]},{c:[{v:'United States'},{v:'US'},{v:3.03605941E8,f:'303605941'},{v:31.0,f:'31'},{v:''}]},{c:[{v:'Indonesia'},{v:'ID'},{v:2.31627E8,f:'231627000'},{v:117.0,f:'117'},{v:''}]},{c:[{v:'Brazil'},{v:'BR'},{v:1.86315468E8,f:'186315468'},{v:22.0,f:'22'},{v:''}]},{c:[{v:'Pakistan'},{v:'PK'},{v:1.626525E8,f:'162652500'},{v:198.0,f:'198'},{v:''}]},{c:[{v:'Bangladesh'},{v:'BD'},{v:1.58665E8,f:'158665000'},{v:1045.0,f:'1045'},{v:''}]},{c:[{v:'Nigeria'},{v:'NG'},{v:1.48093E8,f:'148093000'},{v:142.0,f:'142'},{v:''}]},{c:[{v:'Russia'},{v:'RU'},{v:1.41933955E8,f:'141933955'},{v:8.4,f:'8.4'},{v:''}]},{c:[{v:'Japan'},{v:'JP'},{v:1.2779E8,f:'127790000'},{v:339.0,f:'339'},{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]},{c:[{v:''},{v:'In this sample, we see the Heatmap gadget using two views:'},,,{v:''}]},{c:[{v:''},{v:'The above gadget shows the whole world,'},,,{v:''}]},{c:[{v:''},{v:'and the other gadget shows only Asia.'},,,{v:''}]},{c:[{v:''},{v:'The next sheet in this sample, shows the United States view,'},,,{v:''}]},{c:[{v:''},{v:'which takes data in a different format (U.S. states country code).'},,,{v:''}]},{c:[{v:''},{v:''},,,{v:''}]}]}});<\/span><\/pre>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n\u8868\u683c\u8a2d\u8a08\u898f\u5b9a<\/h2>\n
httpss:\/\/docs.google.com\/support\/bin\/answer.py?hl=en&answer=159999<\/p>\n
![\"\"](\"httpss:\/\/www.powenko.com\/wordpress\/wp-content\/uploads\/2010\/12\/Screen-shot-2010-12-30-at-9.43.41-PM.png\" "\\"Screen")
<\/a><\/p>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n\r\n<\/span><\/pre>\n<\/div>\nReferences:<\/h2>\n
[1]
\nDabble DB – pricing (Web) httpss:\/\/dabbledb.com\/<\/a>
\n[2]
\nGoogle Spreadsheets APIs and Tools(Web) httpss:\/\/code.google.com\/apis\/spreadsheets\/<\/a>
\n[3]
\nDatabase API (Gears API) httpss:\/\/code.google.com\/apis\/gears\/api_database.htm<\/a>l<\/p>\n","protected":false},"excerpt":{"rendered":"\u5982\u4f55\u5728 javascript \u00a0\u628a google spreadsheets \u00a0\u7576\u6210\u8cc7\u6599\u5eab\u4f7f\u7528 tutorial […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-371","post","type-post","status-publish","format-standard","hentry","category-javascript-"],"_links":{"self":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/371"}],"collection":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=371"}],"version-history":[{"count":14,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions"}],"predecessor-version":[{"id":388,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions\/388"}],"wp:attachment":[{"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.powenko.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}