분류 php

PHPSPREADSHEET를 사용하여 PHP에서 CSV 및 EXCEL 파일을 읽는 방법

컨텐츠 정보

  • 조회 2,044 (작성일 )

본문

ref. http://phpspreadsheet.readthedocs.io/en/develop/


1. CSV파일 읽기

<?php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Csv;

$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
$spreadsheet = $reader->load("PATH_TO_YOUR_CSV_FILE");

$sheetData = $spreadsheet->getActiveSheet()->toArray();
print_r($sheetData);
?>


2. Excel 파일 읽기

<?php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet = $reader->load("PATH_TO_YOUR_EXCEL_FILE");

$sheetData = $spreadsheet->getActiveSheet()->toArray();
print_r($sheetData);
?>


php