p081508 - 経済統計練習帳

package keiki;
 
 
import java.io.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
 
public class count {
 
    int supx;
 
    int maxx,maxy;
   Cell cc;
 
 void makedata(String file,int number){   
 
 
 
      try{
 
     FileInputStream is = new FileInputStream(file);
     Workbook wb = new HSSFWorkbook(is);
      Sheet sh = wb.getSheetAt(number);
 
      int s,sx,j,h;
      String bb;
 
 
      int mode;
 
 s=3;
 mode=0;
  while(mode<50){
  s=s+1;
 Row row = sh.getRow(s-1);
  j=0;
  if(row==null)j=100;
  if(j>50)mode=100;
  if(j<60)maxy=s;
  }
 
 
 int x1,j2;
 
 for(s=1;s<maxy+1;s++){
 Row row2 = sh.getRow(s-1);
 j2=0;
 if(row2==null)j2=100;
 if(j2<50){
 x1=0;
 mode=0;  
 for(sx=1;sx<supx;sx++){
 cc = row2.getCell(sx-1);
 j=0;
 if(cc==null)j=100;
 if(j>60)mode=100;
 if(j<60)x1=sx;
 if(x1>maxx)maxx=x1;
 }
 }
 }
 
 
 
 
 
 
  } catch (Exception e) {e.printStackTrace();}
 
 
 
 
 
 
 
 }
}