package com;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
public class pro {
int maxx,maxy;
String[][] mat=new String[500][500];
String[][] data=new String[500][10];
int[] year=new int[500];
int[] month=new int[500];
String[] credit=new String[500];
int[] code_credit=new int[500];
int starty,endy,creditx,credity;
public static void main(String[] args) {
pro test=new pro();
}
pro(){
count sub=new count();
sub.supx=550;
sub.makedata("data.xls",4);
maxx=sub.maxx;
maxy=sub.maxy;
System.out.println(maxx+","+maxy);
readxls sub2=new readxls();
sub2.maxx=maxx;
sub2.maxy=maxy;
sub2.makedata("data.xls",4);
mat=sub2.mat;
writehtml("ren.html");
int s;
double n;
int n1;
starty=7;
endy=87;
creditx=6;
credity=42;
String str;
int yy,mm;
yy=1993;
mm=4;
for(s=starty;s<endy+1;s++){
mm=mm+1;
if(mm>4)yy=yy+1;
if(mm>4)mm=1;
year[s]=yy;
month[s]=mm;
}
for(s=creditx;s<credity+1;s++){
credit[s]=mat[6][s].replace("\n","");
}
writexml("data.txt");
}
void writexml(String file){
int s,sx;
try{
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file)));
for(s=starty;s<endy+1;s++){
for(sx=creditx;sx<credity+1;sx++){
pw.print("<year>");
pw.print(year[s]);
pw.print("</year>");
pw.print("<season>");
pw.print(month[s]);
pw.print("</season>");
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("入出力エラーです。"); }
}
int num(String str){
int i;
i=0;
try {
i = Integer.parseInt(str);
} catch (NumberFormatException e) {}
return i;
}
double num_x(String str){
double i;
i=0;
try {
i = Double.parseDouble(str);
} catch (NumberFormatException e) {}
return i;
}
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("入出力エラーです。"); }
}
}
最終更新：2015年08月15日 07:07
