2014 m. lapkričio 3 d., pirmadienis

PHP: XLS(X) to array

Naudojantis phpExcel
<?php

function convertXLStoArray($infile, $outfile){
 
    if(!file_exists($infile) || !is_readable($infile) || !file_exists($outfile) || !is_readable($outfile))
    return FALSE;
 
    $fileType = PHPExcel_IOFactory::identify($infile);
    $objReader = PHPExcel_IOFactory::createReader($fileType);
 
    $objReader->setReadDataOnly(true);   
    $objPHPExcel = $objReader->load($infile);
    echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
    
  foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
  $arrayData[$worksheet->getTitle()] = $worksheet->toArray();
 }
 
 var_dump($arrayData);
}