lotus - プログラム倉庫

package memo;
 
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import tool.*;
 
public class pro {
 int datanumber;
 
    String[] credit=new String[10];
    int creditnumber;
    String str;
    String[][] subdata=new String[20000][20];
 
    public static void main(String[] args) {
     pro test=new pro();   
    }
 
    pro(){
 
 
 
        String urlx;
        String[] data= new String[600];
        String id;
 
        id="0Atc7WttLh-m7dHBzaWxDMkl0eVNTV3h3NDRhTTVhZnc";
 
 urlx="https://docs.google.com/spreadsheet/pub?key="+id;
 urlx=urlx+"&single=true&gid=0&output=csv";
 
        int s;
 
        getdata sub=new getdata();
        sub.makedata(urlx,"UTF-8");
        data=sub.data;
        datanumber=sub.datanumber;
 
        str=data[1];
 
        String[] x1=str.split(",");
 
        creditnumber=x1.length;
 
        for(s=1;s<creditnumber+1;s++){
        credit[s]=x1[s-1];   
        }
 
        int sx;
 
        for(s=2;s<datanumber+1;s++){
        str=data[s];
        String[] x=str.split(",");
        for(sx=1;sx<x.length+1;sx++){
        subdata[s-1][sx]=x[sx-1];
        }
        }
        datanumber=datanumber-1;
 
 
        writex("ex.jsonp");
 
 
    }
 
    void writex(String file){ 
 
try{ 
 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file)));
 
int s,sx;
 
pw.println("callback(");
pw.println("[");
for(s=1;s<datanumber;s++){ 
pw.print("{");
for(sx=1;sx<creditnumber;sx++){ 
pw.print("\"");
pw.print(credit[sx]);
pw.print("\"");
pw.print(":");
pw.print("\"");
pw.print(subdata[s][sx]);
pw.print("\"");
pw.print(",");
} 
sx=creditnumber;
pw.print("\"");
pw.print(credit[sx]);
pw.print("\"");
pw.print(":");
pw.print("\"");
pw.print(subdata[s][sx]);
pw.print("\"");
pw.println("},");
}
s=datanumber;
pw.print("{");
for(sx=1;sx<creditnumber;sx++){ 
pw.print("\"");
pw.print(credit[sx]);
pw.print("\"");
pw.print(":");
pw.print("\"");
pw.print(subdata[s][sx]);
pw.print("\"");
pw.print(",");
} 
sx=creditnumber;
pw.print("\"");
pw.print(credit[sx]);
pw.print("\"");
pw.print(":");
pw.print("\"");
pw.print(subdata[s][sx]);
pw.print("\"");
pw.println("}");
pw.println("]");
pw.println(");");
 
System.out.println("a"); 
pw.close(); 
} catch(IOException ep){ System.out.println("b"); } 
 
 
} 
}