package read;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Iterator;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class BacaExcel {

    public static void main(String[] args) {
        System.out.println("=== Baca File Excel ===\n");

        try {
            FileInputStream fiStream = new FileInputStream(new File("D:/mahasiswa.xlsx"));
            XSSFWorkbook xw = new XSSFWorkbook(fiStream);
            XSSFSheet sheet = xw.getSheetAt(0);
            Iterator<Row> rowIter = sheet.iterator();

            while(rowIter.hasNext()){
                Row r = rowIter.next();
                Iterator<Cell> cellIter = r.cellIterator();
                while(cellIter.hasNext()){
                    Cell c = cellIter.next();
                    switch(c.getCellType()){
                        case Cell.CELL_TYPE_STRING:
                            System.out.print(c.getStringCellValue()+" ");
                        break;
                        case Cell.CELL_TYPE_NUMERIC:
                        c.setCellType(Cell.CELL_TYPE_STRING);
                            System.out.print(c.getStringCellValue()+" ");
                        break;
                    }
                }
                System.out.println("");
            }
            fiStream.close();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

}