java poi 3.17 读取 excel 2003

 

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>

　　

 

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.Row;

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;

public class ExcelUtils {

    public static void main(String[] args) {
        String excelPath = "/Users/walker/work/private-project/project/excel_process_module/doc/武汉-枣庄-20200322.xls";
        try {
            readExcel2003(excelPath);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
//    List<List<String>>
    public static void readExcel2003(String fileName) throws Exception{
//      创建一个输入流
        FileInputStream inputStream = new FileInputStream(fileName);
//      创建一个workbook
        HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
//      创建一个sheet对象，参数为sheet的索引
        HSSFSheet sheet = workbook.getSheetAt(0);
//      创建存放一张表的二位数组
        List<List<String>> allDataList = new ArrayList<>();

        for(Row row:sheet){
            List<String> oneRowList = new ArrayList<>();
//          不读取表头
            if(row.getRowNum() == 0){
                continue;
            }
            for (Cell cell : row) {
                cell.setCellType(cell.CELL_TYPE_STRING);
                oneRowList.add(cell.getStringCellValue().trim());
            }
            allDataList.add(oneRowList);
        }

        for(int i = 0; i <allDataList.size(); i++){
            System.out.println(allDataList.get(i));
        }
//      关闭workbook
//        return allDataList;
    }
}