[PHP] phpoffice spreadsheet 읽기

파일 업로드 후 데이터 읽기

 

$data = $this->upload->data();

switch (str_replace('.', '', $data['file_ext'])){
  case 'xls':
  	$inputFileType = 'Xls';
  	break;
  case 'xlsx':
  	$inputFileType = 'Xlsx';
  	break;
  case 'csv':
  	$inputFileType = 'Csv';
  	break;
  default:
 	$inputFileType = '';
    break;
}

if(isset($inputFileType) and !empty($inputFileType)){
  /**  Create a new Reader of the type defined in $inputFileType  **/
  $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
  /**  Advise the Reader that we only want to load cell data  **/
  $reader->setReadDataOnly(true);
  /**  Advise the Reader of which WorkSheets we want to load  **/
  $reader->setLoadSheetsOnly('Sheet1');
  /**  Load $inputFileName to a Spreadsheet Object  **/
  $spreadsheet = $reader->load($data['full_path']);
  $sheet = $spreadsheet->getActiveSheet();

  $spreadsheetData = $sheet->toArray();
  // 0 번 라인은 컬럼 설명 라인이므로 제외
  $insert_batch_data = array();
  for($i=2; $i < count($spreadsheetData); $i++){
  	$lineData = $spreadsheetData[$i];
	//데이터 처리 결정
  }
}