しぃおいい - 経済統計練習帳

package w1;
 
import java.io.*;
 
public class pro {
 
     int maxx=150;
        int maxy=100;
    String[][] mat=new String[300][300]; 
    int fastline;    
    int lastline;    
    String[] pref=new String[300];
     String[] credit=new String[300];
int creditx,credity;
 String[] code=new String[300];
    String[] year=new String[300];
    public static void main(String[] args) {
        pro te=new pro();
    }
 
    pro(){
 
 
        int de;
 
        for(de=2007;de<2018;de++){
        String a=""+de;
 
        File f=new File(a);
        String[] ff=f.list();
 
        int tr;
 
        for(tr=0;tr<ff.length;tr++){
 
         readxls sub2=new readxls();
    sub2.maxx=maxx;
    sub2.maxy=maxy;
    sub2.makedata(a+"/"+ff[tr],0);
    mat=sub2.mat;
 
    writehtml("ren.html");
 
    int prefline=0;
 
    int s,sx;
for(s=1;s<21;s++){
for(sx=1;sx<11;sx++){
int h=0;
if(mat[s][sx].indexOf("北")>-1)h=h+1;
if(mat[s][sx].indexOf("海")>-1)h=h+1;
if(h==2)prefline=sx;
if(h==2)fastline=s;
}
}
for(s=fastline;s<81;s++){
int h=0;
if(mat[s][prefline].indexOf("沖")>-1)h=h+1;
if(mat[s][prefline].indexOf("縄")>-1)h=h+1;
if(h==2)lastline=s;
}
 
System.out.println(fastline);
System.out.println(lastline);
 
for(s=fastline;s<lastline+1;s++){
pref[s]=mat[s][prefline];
System.out.println(pref[s]);
}
 
int creditline=0;
 
 
for(s=1;s<fastline;s++){
for(sx=1;sx<11;sx++){
int h=0;
if(mat[s][sx].indexOf("#")>-1)h=h+1;
if(creditline==0)h=h+1;
if(h==2)creditline=s;
if(h==2)creditx=sx;
}    
}        
 
 
System.out.println(creditline);  
System.out.println(creditx);  
 
for(sx=creditx;sx<maxx;sx++){
if(mat[creditline][sx].indexOf("#")>-1)credity=sx;
}        
 
System.out.println(credity);  
 
for(sx=creditx;sx<credity+1;sx++){
credit[sx]=mat[creditline-4][sx]+mat[creditline-3][sx]+mat[creditline-2][sx];
code[sx]=mat[creditline][sx];
year[sx]=mat[creditline+2][sx];
System.out.println(code[sx]);  
}       
 
writexml("gdata/"+a+"/"+ff[tr]+".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++){  
if(pref[s].length()>1){
for(sx=creditx;sx<credity+1;sx++){ 
if(code[sx].indexOf("#")>-1){
pw.print("<pref>");
pw.print(pref[s]);
pw.print("</pref>"); 
pw.print("<year>");
pw.print(year[sx]);
pw.print("</year>"); 
pw.print("<credit>");
pw.print(credit[sx]);
pw.print("</credit>"); 
pw.print("<code>");
pw.print(code[sx]);
pw.print("</code>"); 
pw.print("<value>");
pw.print(mat[s][sx]);
pw.println("</value>"); 
}
}
}
}
 
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
 
 
    void writehtml(String file){ 
 
    int s,sx;
 
try{ 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file))); 
 
 
pw.println("<html>");
 
pw.println("<head>");
pw.println("<meta charset=\"UTF-8\">");
pw.println("</head>");
pw.println("<body>");
pw.print("<table rules=\"all\">"); 
pw.print("<tr>"); 
pw.print("<td>"); 
pw.print(""); 
pw.print("</td>"); 
for(sx=1;sx<maxx+1;sx++){ 
pw.print("<th>"); 
pw.print(sx); 
pw.print("</th>"); 
} 
pw.println("</tr>"); 
for(s=1;s<maxy+1;s++){ 
pw.print("<tr>"); 
pw.print("<th>"); 
pw.print(s); 
pw.print("</th>"); 
for(sx=1;sx<maxx+1;sx++){ 
pw.print("<td>"); 
pw.print(mat[s][sx]); 
pw.print("</td>"); 
} 
pw.println("</tr>"); 
}   
pw.println("</table>"); 
pw.println("</body>");
pw.println("</html>");
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
 
}