CSVParser.php

Go to the documentation of this file.

<?php
 
namespace SimpleExcel\Parser;

use SimpleExcel\Exception\SimpleExcelException;

class CSVParser extends BaseParser implements IParser
{    
    protected $delimiter;
    
    protected $file_extension = 'csv';

    public function loadFile($file_path){
    
        if (!$this->isFileReady($file_path)) {
            return;
        }

        $this->loadString(file_get_contents($file_path));
    }
    
    public function loadString($str){
        $this->table_arr = array();
        
        if(!isset($this->delimiter)){
            $numofcols = NULL;
            // assume the delimiter is semicolon
            while(($line = str_getcsv($str, ';')) !== FALSE){
                if($numofcols === NULL){
                    $numofcols = count($line);
                }
                // check the number of values in each line
                if(count($line) === $numofcols){
                    array_push($this->table_arr, $line);
                } else {
                    // maybe wrong delimiter
                    // empty the array back
                    $this->table_arr = array();
                    $numofcols = NULL;
                    break;
                }
            }
            // if null, check whether values are separated by commas
            if($numofcols === NULL){
                while(($line = str_getcsv($str, ',')) !== FALSE){
                    array_push($this->table_arr, $line);
                }
            }
        } else {
            while(($line = str_getcsv($str, $this->delimiter)) !== FALSE){
                array_push($this->table_arr, $line);
            }
        }
    }
    
    public function setDelimiter($delimiter){
        $this->delimiter = $delimiter;
    }
}