ｍ００ - 経済統計練習帳

package gdp2;
 
import java.io.*;
 
public class pro {
 
 
      String[][] mat=new String[300][300]; 
    int fastline,lastline;
   String[] pref=new String[300]; 
     String[] credit=new String[300]; 
 
    public static void main(String[] args) {
        pro test=new pro();
    }
 
    pro(){
 
        int maxx=100;
        int maxy=100;
 
        int tr=0;
        for(tr=0;tr<13;tr++){
     readxls sub2=new readxls();
    sub2.maxx=maxx;
    sub2.maxy=maxy;
    sub2.makedata("data.xls",tr);
    mat=sub2.mat;
 
    fastline=9;
    lastline=55;
 
    int s,sx;
    for(s=fastline;s<lastline+1;s++){
    pref[s]=mat[s][2];
        System.out.println(s+","+mat[s][2]);    
    }
 
 
    for(s=1;s<101;s++){
    credit[s]=mat[5][s]+mat[6][s]+mat[7][s];
    credit[s]=credit[s].replace("\n","");
    credit[s]=credit[s].replace("　","");
    credit[s]=credit[s].replace("都道府県","");
    System.out.println(s+","+credit[s]);    
    }
 
 
    writexml("data/"+(tr+2001)+".txt");
        }
 
 
    }
 
 
    void writexml(String file){ 
 
    int s,sx;
 
try{ 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file))); 
 
for(s=fastline;s<lastline+1;s++){  
for(sx=4;sx<60;sx++){ 
if(credit[sx].length()>0){
pw.print("<pref>");
pw.print(pref[s]);
pw.print("</pref>");
pw.print("<credit>");
pw.print(credit[sx]);
pw.print("</credit>");
pw.print("<value>");
pw.print(mat[s][sx]);
pw.println("</value>");
}   
}
}
 
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
}