拆分文件,将较大文件根据具体行数拆分,主要用于提取数据时,数据量大而在excel展示不成功。将其拆分为具体行数,然后分sheet展示
public static void main(String[] args) {
FileReader fr = null;
BufferedReader bf = null;
FileWriter fw = null;
BufferedWriter bw = null;
try {
fr = new FileReader("D:\\test\\allpolicy.unl");//需要拆分的文件
System.out.println(fr.toString());
bf = new BufferedReader(fr);
fw = new FileWriter("D:\\test\\allpolicy\\allpolicy1.unl",false);//拆分之后的文件
bw = new BufferedWriter(fw);
int i = 0;
int j = 1;
String str = null;
while((str=bf.readLine())!=null){
if(i==10000){//行数
bw.flush();
i=0;
j++;
fw = new FileWriter("D:\\test\\allpolicy\\allpolicy"+j+".unl",false);//拆分之后的文件
bw = new BufferedWriter(fw);
}
if(i!=0)
bw.newLine();
bw.write(str);
i++;
}
bw.flush();
System.out.println("over");
// fr.
} catch (Exception e) {
e.printStackTrace();
}finally{
if(fr!=null){
try {
fr.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(bf!=null){
try {
fr.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(fw!=null){
try {
fr.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(bw!=null){
try {
fr.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}