java poi 导入导出Excel xsl xslx

poi包：http://download.csdn.net/detail/ptzrbin/5212952

 

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 FFF {  
    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();  
        }  
    }  
}