java 创建excel文件_java批量生成excel文件

packagetest.job.day1130;importjava.io.BufferedInputStream;importjava.io.BufferedOutputStream;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.InputStream;importjava.io.OutputStream;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;public classExcelUtil {private File createExcelFile(String path,String fileName)throwsException{

InputStream in= null;

OutputStream out= null;

File excelFile=createNewFile(path,fileName);//System.out.println(excelFile.getName());//模版

File templateFile = new File(path+"/template","template.xls");if(!templateFile.exists())throw new Exception("模版文件不存在");//System.out.println(templateFile.getName());

try{

in= new BufferedInputStream(new FileInputStream(templateFile),1024);

out= new BufferedOutputStream(new FileOutputStream(excelFile),1024);byte[] buffer = new byte[1024];intlen;while((len=in.read(buffer)) != -1){

out.write(buffer,0,len);

out.flush();

}

}finally{if(in != null)

in.close();if(out != null)

out.close();

}returnexcelFile;

}/*初始化excel文件*/

private void initExcelFile(File excelFile,String prefix)throwsException{

InputStream is= null;

OutputStream out= null;

HSSFWorkbook workbook= null;

HSSFSheet sheet= null;

is= newFileInputStream(excelFile);

workbook= newHSSFWorkbook(is);

String suffix= "";//获取第一个sheet

sheet = workbook.getSheetAt(0);if(sheet != null){//写数据

for(int i=0;i<399;i++){

HSSFRow row=sheet.createRow(i);

HSSFCell cell= row.createCell(0);if(i == 0){

cell.setCellValue("帐号");

cell= row.createCell(1);

cell.setCellValue("密码");continue;

}if(i < 10){

suffix= "00" +i;

}else if(i < 100){

suffix= "0" +i;

}else{

suffix= i + "";

}

cell.setCellValue(prefix+suffix);

cell= row.createCell(1);

cell.setCellValue("000000");

}

out= newFileOutputStream(excelFile);

workbook.write(out);

}

out.flush();

out.close();

}private File createNewFile(String path,String fileName)throwsException{

File newFile= newFile(path,fileName);if(!newFile.exists())

newFile.createNewFile();returnnewFile;

}public static void main(String[] args)throwsException{

String path= "d:/excelFiles";

String fileName= "";

String prefix= "";

String tmpStr= "";//char[] charArr = {'A','B','C','D','E','F','G','H','I','J'};

char[] charArr = {'O','P','Q'};long t0 =System.currentTimeMillis();for(int i=0;i

tmpStr= "0" +j;

}else{

tmpStr= "" +j;

}

prefix= charArr[i] +tmpStr;

fileName= "file" + prefix + ".xls";

ExcelUtil eu= newExcelUtil();

System.out.println("正在创建 " + fileName + "文件..");

File f=eu.createExcelFile(path,fileName);

eu.initExcelFile(f,prefix);

}

}long t1 =System.currentTimeMillis();

System.out.println("耗时：" + (t1-t0)/1000 + "秒钟");//String fileName = "file000.xls";//ExcelUtil eu = new ExcelUtil();//File f = eu.createExcelFile(path,fileName);//eu.initExcelFile(f,"a00");

}

}