java poi api测试类.docx

基于poi 3.8 各个poi方法详解1、package com.rensanning.poi;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;public abstract class AbstractSample {public Workbook readExcelFile(String filename) {FileInputStream in = null;Workbook wb = null;try {in = new FileInputStream(filename);wb = WorkbookFactory.create(in);} catch (IOException e) {System.out.println(e.toString());} catch (InvalidFormatException e) {System.out.println(e.toString());} finally {try {in.close();} catch (IOException e) {System.out.println(e.toString());}}return wb;}public void createExcelFile(Workbook wb, String filename) {FileOutputStream out = null;try {out = new FileOutputStream(filename);wb.write(out);} catch (IOException e) {System.out.println(e.toString());} finally {try {out.close();} catch (IOException e) {System.out.println(e.toString());}}}}2、package com.rensanning.poi;import java.io.BufferedInputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import org.apache.poi.hssf.record.crypto.Biff8EncryptionKey;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.poifs.filesystem.POIFSFileSystem;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class T1_Workbook extends AbstractSample {private static String FILE_DIR = c:\\sample\\poi\\;private static final String TEST_WORKBOOK_NAME = FILE_DIR + sample_workbook.xls;private static final String TEST_WORKBOOK_NAME2 = FILE_DIR + sample_workbook.xlsx;private static final String TEST_WORKBOOK_NAME_ENCRYPTED = resource/sample_wo