poi简单的导入和导出Excel表格（xls。xlsx）

来源：互联网发布：2016淘宝c店越来越难做编辑：程序博客网时间：2024/04/30 22:11

package com.excel.lx;

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 Demo {
    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 = wb.createSheet("sheet1");
        //循环写入行数据
        for (int i = 0; i < 5; i++) {
            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业
        Sheet sheet1 = wb.getSheetAt(0);

        for (Row row : sheet1) {
            for (Cell cell : row) {
                System.out.print(cell.getStringCellValue()+" ");
            }
            System.out.println();
        }
    }
}

阅读全文

0 0