import java.io.FileInputStream;

import java.util.*;

import org.apache.poi.hssf.usermodel.*;

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

import kr.inflearn.ExcelVO;

public class Project03_A {

public static void main(String[] args) {

String fileName="bookList.xls";

List<ExcelVO> data=new ArrayList<ExcelVO>();

try(FileInputStream fis=new FileInputStream(fileName)) {

HSSFWorkbook workbook=new HSSFWorkbook(fis);

HSSFSheet sheet=workbook.getSheetAt(0);

Iterator<Row> rows=sheet.rowIterator();

rows.next();

String[] imsi=new String[5];

while(rows.hasNext()) {

HSSFRow row=(HSSFRow) rows.next();

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

int i=0;

while(cells.hasNext()) {

HSSFCell cell=(HSSFCell) cells.next();

imsi[i]=cell.toString();

i++;

}

// ¹­°í(VO)->´ã°í(List)

ExcelVO vo=new ExcelVO(imsi[0],imsi[1],imsi[2],imsi[3],imsi[4]);

data.add(vo);

}

showExcelData(data);

} catch (Exception e) {

e.printStackTrace();

}

}

public static void showExcelData(List<ExcelVO> data) {

for(ExcelVO vo : data) {

System.out.println(vo);

}

}

}