package com.lovecoding.execel;

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 java.io.FileInputStream;
import java.io.IOException;

public class ExecelAction {
    public static void main(String[] args) throws IOException {
        //我们表格文件存储地址
        String path = "day15/demo.xlsx";
        //我们创建一个表格的文件流
        FileInputStream fileInputStream = new FileInputStream(path);
        //创建XSSFWorkbook 对象
        XSSFWorkbook sheets = new XSSFWorkbook(fileInputStream);
        //我们要设置我们读取的Sheet
        XSSFSheet sheet = sheets.getSheetAt(0);
        //获取Execel表格行数
        int lastRowNum = sheet.getLastRowNum();
        //循环表格的每一行
        for (int i = 0; i < lastRowNum; i++) {
            //获取到表的一行
            XSSFRow row = sheet.getRow(i);
            //取这一样有多少列
            short lastCellNum = row.getLastCellNum();
            //循环每一列
            for (int j = 0; j < lastCellNum; j++) {
                //具体取每一个单元格
                XSSFCell cell = row.getCell(j);
                //设置转换类型
                cell.setCellType(CellType.STRING);
                //获取单元格数据
                String stringCellValue = cell.getStringCellValue();
                //打印单元格数据
                System.out.println( stringCellValue );
            }
        }
    }
}