ｆｙ - 経済統計練習帳

google.load("visualization", "1", {packages:["corechart"]});
 
function play(){
 
var query = new google.visualization.Query(
      'https://docs.google.com/spreadsheets/d/1TUISotdjLRT1Ji6XJVdp3krG5lO-dYC0PjHajq9F3nA/edit?usp=sharing');
query.send(handleQueryResponse);
}
 
function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
 
 
var number;
 
var data=new Array();
var x=new Array();
 
 
number=20;
 
var s;
 
for(s=0;s<number+1;s++){
data[s]=new Array();
}
 
 
for(s=0;s<number+1;s++){
data[s][0]=s+1;
data[s][1]=response.getDataTable().getValue(s+1,0);
}
 
var obj = { width: 500, height: 500, title: "練習",resizable:true,draggable:true };
obj.colModel = [{ title: "Rank", width: 200, dataType: "integer" },
{ title: "Company", width: 300, dataType: "float" }];
obj.dataModel = { data: data };
$("#grid").pqGrid(obj);
}