しょりでーた - 経済統計練習帳

package datax;
 
 
import java.io.*;
 
public class memo {
 
    String[][] mat=new String[500][500];
    String[] year=new String[500];
      String[] pref=new String[500];
     String[] credit=new String[500];
       int fastline=0;
    int prefline=0;
    int lastline=0;
 
 
    void makedata(String file,String filex){
 
        int maxx=400;
        int maxy=100;
 
   readxls sub=new readxls();
    sub.maxx=maxx;
    sub.maxy=maxy;
    sub.makedata(file,0);
    mat=sub.mat;
 
 
 
    int s,sx;
    for(s=1;s<21;s++){
    for(sx=1;sx<5;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;
     }
 
    }
 
 
         System.out.println(fastline);  
         System.out.println(prefline);  
 
    for(s=1;s<80;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;
    }
 
 
 
     int yearline=fastline-3;   
    int creditline=yearline-7;
 
 
    for(s=prefline+1;s<370;s++){
    year[s]=mat[yearline][s];
    credit[s]=mat[creditline][s]+mat[creditline+1][s]+mat[creditline+2][s];
    if(credit[s].length()<1)credit[s]=credit[s-1];
    }
 
 
    writexml(filex);    
 
 
    }
 
     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=prefline+1;sx<340;sx++){ 
if(year[sx].length()>0){
pw.print("<year>"); 
pw.print(year[sx]); 
pw.print("</year>"); 
pw.print("<pref>");
pw.print(mat[s][prefline]);
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("入出力エラーです。"); } 
 
 
} 
 
 
 
}
 
package datax;
 
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
 
public class readxls{
 
    int pointx,pointy;
    int px,py;
    int maxx,minx,miny,maxy;
int creditrow;
    int checkline,checkx;
    String[][] mat=new String[200][5000];
 
 
  void makedata(String file,int shnumber){  
 
 
 
      try{
 
    FileInputStream is = new FileInputStream(file);
    Workbook wb = new HSSFWorkbook(is);
    Sheet sh = wb.getSheetAt(shnumber);
 
    int s,sx;
    int h1,h2;
 
    String str;
    for(s=miny;s<maxy+1;s++){
    for(sx=minx;sx<maxx+1;sx++){
    mat[s][sx]="";
    }
    }
 
    for(s=miny;s<maxy+1;s++){
    Row row = sh.getRow(s-1);
     h1=0;
    if(row==null)h1=100;
    if(h1<50){
    for(sx=minx;sx<maxx+1;sx++){
    Cell cell = row.getCell(sx-1);
    str="";
    h2=0;
    if(cell==null)h2=100;
    if(h2<50){
    int type =cell.getCellType();
    str="";
  if(type==0)str=""+cell.getNumericCellValue();
  if(type==1)str=cell.getStringCellValue();
   mat[s][sx]=str;
    }
    }
    }
    }
 
 
 
 
      } catch (Exception e) {e.printStackTrace();}
 
 
 
 
 
 
 
 
  }
}
 
package datax;
 
 
import java.io.*;
 
public class memo {
 
    String[][] mat=new String[500][500];
    String[] year=new String[500];
      String[] pref=new String[500];
     String[] credit=new String[500];
       int fastline=0;
    int prefline=0;
    int lastline=0;
 
 
    void makedata(String file,String filex){
 
        int maxx=400;
        int maxy=100;
 
   readxls sub=new readxls();
    sub.maxx=maxx;
    sub.maxy=maxy;
    sub.makedata(file,0);
    mat=sub.mat;
 
 
 
    int s,sx;
    for(s=1;s<21;s++){
    for(sx=1;sx<5;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;
     }
 
    }
 
 
         System.out.println(fastline);  
         System.out.println(prefline);  
 
    for(s=1;s<80;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;
    }
 
 
 
     int yearline=fastline-3;   
    int creditline=yearline-7;
 
 
    for(s=prefline+1;s<370;s++){
    year[s]=mat[yearline][s];
    credit[s]=mat[creditline][s]+mat[creditline+1][s]+mat[creditline+2][s];
    if(credit[s].length()<1)credit[s]=credit[s-1];
    }
 
 
    writexml(filex);    
 
 
    }
 
     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=prefline+1;sx<340;sx++){ 
if(year[sx].length()>0){
pw.print("<year>"); 
pw.print(year[sx]); 
pw.print("</year>"); 
pw.print("<pref>");
pw.print(mat[s][prefline]);
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("入出力エラーです。"); } 
 
 
} 
 
 
 
}