인프런 커뮤니티 질문&답변

구글 스프레드 시트를 이용한다.

xlsx 파일로 다운로드한다.

https://huskdoll.tistory.com/890

위의 블로그에서 파일들을 다운로드한다.

아래처럼 코드를 입력한다.

끝

package com.company;

import com.company.kr.inflearn.ExcelVO;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
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.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class Project03_A {
  public static void main(String[] args) {
    String fileName = "bookList.xlsx";

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

    try(FileInputStream fis = new FileInputStream(fileName)) {
//      HSSFWorkbook workbook = new HSSFWorkbook(fis); // xls
//      HSSFSheet sheet = workbook.getSheetAt(0); // xls
      XSSFWorkbook workbook = new XSSFWorkbook(fis); // xlsx
      XSSFSheet sheet = workbook.getSheetAt(0); // xlsx

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

      String[] imsi = new String[5];

      while (rows.hasNext()) {
//        HSSFRow row = (HSSFRow) rows.next(); // xls
        XSSFRow row = (XSSFRow) rows.next(); // xlsx
        Iterator<Cell> cells = row.cellIterator();
        int i=0;
        while (cells.hasNext()) {
//          HSSFCell cell = (HSSFCell) cells.next(); // xls
          XSSFCell cell = (XSSFCell) cells.next(); // xlsx
          imsi[i] = cell.toString();
          i++;
        }
        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);
    }
  }
}