package com.tanruyu.demo;

import java.io.File;

import java.io.FileInputStream;

import java.util.Iterator;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadXlsx {

    public static void main(String[] args) throws Exception {

        XSSFRow row = null;

        // 1. 讀取文件輸入流

        FileInputStream fis = new FileInputStream(new File("f:/WriteSheet.xlsx"));

        XSSFWorkbook workbook = new XSSFWorkbook(fis);

        // 2. 獲取 sheet

        XSSFSheet spreadsheet = workbook.getSheetAt(0);

        Iterator<Row> rowIterator = spreadsheet.iterator();

        while (rowIterator.hasNext()) {

            // 獲得行 迭代

            row = (XSSFRow) rowIterator.next();

            // 獲得單元格

            Iterator<Cell> cellIterator = row.cellIterator();

            while (cellIterator.hasNext()) {

                Cell cell = cellIterator.next();

                // 單元格數(shù)據(jù)類型

                switch (cell.getCellType()) {

                // case Cell.CELL_TYPE_NUMERIC:

                // System.out.print(cell.getNumericCellValue() + " \t\t ");

                // break;

                case Cell.CELL_TYPE_STRING:

                    System.out.print(cell.getStringCellValue() + " \t\t ");

                    break;

                }

            }

            System.out.println();

        }

        fis.close();

    }

}