x3487 - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
function sample(){
 
google.script.run
       .withSuccessHandler(function(q) {
           f(q);
 
          })
       .withFailureHandler(function(msg) {})
       .step();
 
 
 
}
 
function f(q){
 
var name=new Array();
var pic=new Array();
 
number=q.length;
 
var str="<table>";
 
for(s=0;s<q.length;s++){
var x=q[s].split(",");
name[s+1]=x[0];
pic[s+1]=x[1];
}
 
 
for(s=1;s<number+1;s++){
str=str+"<tr><td>"+name[s]+"</td>";
 
p2="http://web-m.webcdn.stream.ne.jp/www09/web-m/ske48/img/profile/small/"+pic[s];
p2="<img src=\""+p2+"\"  width=100 height=100>";
str=str+"<td>"+p2+"</td></tr>";
}
str=str+"</table>";
 
$("#memo").html(str);
 
 
}
 
 
</script>
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('Index');
 
 
  return template.evaluate()
      .setTitle('練習')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function step() {
 
 
  var doc = DocumentApp.openById("1IRMK2D4YstRAUszPmBxB_NeQKPVU0aGZiAjiTx0ekbM");
 
 
  var f=doc.getText();
 
  var q=f.split("\n");
 
 
 
 return q;
 
}