CodeIgniter + PHPExcel 備忘録

CodeIgniter + PHPExcel 備忘録

PHPExcelとPHPExcel.php は /application/libraries/配下に配置。

/application/libraries/PHPExcel
/application/libraries/PHPExcel.php

あとはこんな感じで利用できる。

require_once 'application/libraries/PHPExcel.php';
require_once 'application/libraries/PHPExcel/IOFactory.php';

$objPHPExcel = new PHPExcel();
$objPHPExcel = PHPExcel_IOFactory::load($file);

$data = array();
$cells = $objPHPExcel->getActiveSheet()->getCellCollection();
foreach ($cells as $cell) {
    $col = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn();
    $row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow();
    $val = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue();
    $data[$row][$col] = $val;
}