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 data=new ArrayList();
try(FileInputStream fis=new FileInputStream(fileName)) {
HSSFWorkbook workbook=new HSSFWorkbook(fis);
HSSFSheet sheet=workbook.getSheetAt(0);
Iterator rows=sheet.rowIterator();
rows.next();
String[] imsi=new String[5];
while(rows.hasNext()) {
HSSFRow row=(HSSFRow) rows.next();
Iterator| 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 data) {
for(ExcelVO vo : data) {
System.out.println(vo);
}
}
}
|