Javad对excel实现读写

1.首先导入依赖

    

        
            org.apache.poi
            poi
            3.17
        

        
            org.apache.poi
            poi-ooxml
            3.17
        
        
            junit
            junit
            4.12
        

    

2.两个依赖，分别是poi和poi-ooxml对应后缀名不同的excel xls和xlsx,这里默认使用xlsx的

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;

import java.io.*;
import java.util.HashMap;
import java.util.Map;

public class ExcelTest {
    @Test
    public  void creatAndWrite()  {
        FileOutputStream out= null;
        try {
            out = new FileOutputStream("F:\test.xlsx");
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
        XSSFWorkbook book=new XSSFWorkbook();
        //生成sheet页
        XSSFSheet sheet= book.createSheet("sheet1");
        //生成头部行 rownum对应行数-1
        XSSFRow row = sheet.createRow(0);
        XSSFCell cell1 = row.createCell(0);
        cell1.setCellValue("编号");
        XSSFCell cell2 = row.createCell(1);
        cell2.setCellValue("姓名");
        XSSFCell cell3 = row.createCell(2);
        cell3.setCellValue("日期");

        //从此行开始写入数据
        //如有多行数据 循环即可
        XSSFRow row1 = sheet.createRow(1);
        XSSFCell cell11 = row1.createCell(0);
        cell11.setCellValue(1);

        XSSFCell cell12 = row1.createCell(1);
        cell12.setCellValue("tom");

        XSSFCell cell13 = row1.createCell(2);
        cell13.setCellValue("2012-02-15");
        try {
            book.write(out);
        } catch (IOException e) {
            e.printStackTrace();
        }


    }

    @Test
    public void read(){
        Map map=new HashMap<>();
        try {
            FileInputStream in=new FileInputStream("F:\test.xlsx");
            XSSFWorkbook book=new XSSFWorkbook(in);
            XSSFSheet sheet1 = book.getSheet("sheet1");
            XSSFRow row = sheet1.getRow(1);
            for(int i=0;i 

对应测试结果：