package xls;
import java.io.*;
import java.io.File;
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(){
File ff=new File("data");
String[] f=ff.list();
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/"+f[tr],0);
mat=sub2.mat;
fastline=7;
lastline=53;
int s,sx;
for(s=fastline;s<lastline+1;s++){
pref[s]=mat[s][2];
System.out.println(s+","+mat[s][2]);
}
for(s=4;s<18;s++){
credit[s]=""+(int)num_double(mat[5][s]);
System.out.println(s+","+credit[s]);
}
writexml("gdata/"+(tr+1)+".txt");
}
}
double num_double(String str){
double nx;
nx=0;
try{
nx=Double.parseDouble(str);
}catch (Exception e) {}
return nx;
}
void writexml(String file){
int s,sx;
try{
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file)));
pw.println("p,code,year,v");
for(s=fastline;s<lastline+1;s++){
for(sx=4;sx<18;sx++){
pw.print(pref[s]);
pw.print(",p");
pw.print(s-fastline+1);
pw.print(",");
pw.print(credit[sx]);
pw.print(",");
pw.println(mat[s][sx]);
}
}
System.out.println("ファイルに書きこみました。");
pw.close();
} catch(IOException ep){ System.out.println("入出力エラーです。"); }
}
}
最終更新:2017年03月09日 14:59