java poi api测试类.docx

基于poi3.8各个poi方法详解

1、
packagecom.rensanning.poi;

importjava.io.FileInputStream;
importjava.io.FileOutputStream;
importjava.io.IOException;

importorg.apache.poi.openxml4j.exceptions.InvalidFormatException;
importorg.apache.poi.ss.usermodel.Workbook;
importorg.apache.poi.ss.usermodel.WorkbookFactory;

publicabstractclassAbstractSample{

publicWorkbookreadExcelFile(Stringfilename){
FileInputStreamin=null;
Workbookwb=null;

try{
in=newFileInputStream(filename);
wb=WorkbookFactory.create(in);
}catch(IOExceptione){
System.out.println(e.toString());
}catch(InvalidFormatExceptione){
System.out.println(e.toString());
}finally{
try{
in.close();
}catch(IOExceptione){
System.out.println(e.toString());
}
}

returnwb;
}

publicvoidcreateExcelFile(Workbookwb,Stringfilename){
FileOutputStreamout=null;

try{
out=newFileOutputStream(filename);
wb.write(out);
}catch(IOExceptione){
System.out.println(e.toString());
}finally{
try{
out.close();
}catch(IOExceptione){
System.out.println(e.toString());
}
}
}

}

2、
packagecom.rensanning.poi;

importjava.io.BufferedInputStream;
importjava.io.File;
importjava.io.FileInputStream;
importjava.io.FileNotFoundException;
importjava.io.IOException;

importorg.apache.poi.hssf.record.crypto.Biff8EncryptionKey;
importorg.apache.poi.hssf.usermodel.HSSFSheet;
importorg.apache.poi.hssf.usermodel.HSSFWorkbook;
importorg.apache.poi.openxml4j.exceptions.InvalidFormatException;
importorg.apache.poi.poifs.filesystem.POIFSFileSystem;
importorg.apache.poi.ss.usermodel.Sheet;
importorg.apache.poi.ss.usermodel.Workbook;
importorg.apache.poi.ss.usermodel.WorkbookFactory;
importorg.apache.poi.xssf.usermodel.XSSFWorkbook;

publicclassT1_WorkbookextendsAbstractSample{

privatestaticStringFILE_DIR="c:\\sample\\poi\\";

privatestaticfinalStringTEST_WORKBOOK_NAME=FILE_DIR+"sample_workbook.xls";
privatestaticfinalStringTEST_WORKBOOK_NAME2=FILE_DIR+"sample_workbook.xlsx";