poi写入读取excel 2007版xlsx 97版xls

poi写入读取excel 2007版xlsx 97版xls

package cn.com.cloud.sea.office.test;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class TestReadAndWrite {public static void main(String[] args) throws IOException {String path = "d:/";String fileName = "test";String fileType = "xlsx";writer(path, fileName, fileType);read(path, fileName, fileType);}private static void writer(String path, String fileName,String fileType) throws IOException {//创建工作文档对象Workbook wb = null;if (fileType.equals("xls")) {wb = new HSSFWorkbook();}else if(fileType.equals("xlsx")){wb = new XSSFWorkbook();}else{System.out.println("您的文档格式不正确！");}//创建sheet对象Sheet sheet1 = (Sheet) wb.createSheet("sheet1");//循环写入行数据for (int i = 0; i < 5; i++) {Row row = (Row) sheet1.createRow(i);//循环写入列数据for (int j = 0; j < 8; j++) {Cell cell = row.createCell(j);cell.setCellValue("测试"+j);}}//创建文件流OutputStream stream = new FileOutputStream(path+fileName+"."+fileType);//写入数据wb.write(stream);//关闭文件流stream.close();}public static void read(String path,String fileName,String fileType) throws IOException{InputStream stream = new FileInputStream(path+fileName+"."+fileType);Workbook wb = null;if (fileType.equals("xls")) {wb = new HSSFWorkbook(stream);}else if (fileType.equals("xlsx")) {wb = new XSSFWorkbook(stream);}else {System.out.println("您输入的excel格式不正确");}Sheet sheet1 = wb.getSheetAt(0);for (Row row : sheet1) {for (Cell cell : row) {System.out.print(cell.getStringCellValue()+"  ");}System.out.println();}}}