CSV.php

Go to the documentation of this file.

<?php
if (!defined('PHPEXCEL_ROOT')) {
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
}

require_once PHPEXCEL_ROOT . 'PHPExcel.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Reader/IReader.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Worksheet.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Cell.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Reader/DefaultReadFilter.php';


class PHPExcel_Reader_CSV implements PHPExcel_Reader_IReader
{
        private $_delimiter;

        private $_enclosure;

        private $_lineEnding;

        private $_sheetIndex;

        private $_readFilter = null;

        public function __construct() {
                $this->_delimiter       = ',';
                $this->_enclosure       = '"';
                $this->_lineEnding      = PHP_EOL;
                $this->_sheetIndex      = 0;
                $this->_readFilter      = new PHPExcel_Reader_DefaultReadFilter();
        }
        
        public function canRead($pFilename) 
        {
                // Check if file exists
                if (!file_exists($pFilename)) {
                        throw new Exception("Could not open " . $pFilename . " for reading! File does not exist.");
                }
                
                // Check if it is a CSV file (using file name)
                return (substr(strtolower($pFilename), -3) == 'csv');
        }

        public function load($pFilename)
        {
                // Create new PHPExcel
                $objPHPExcel = new PHPExcel();

                // Load into this instance
                return $this->loadIntoExisting($pFilename, $objPHPExcel);
        }

        public function getReadFilter() {
                return $this->_readFilter;
        }

        public function setReadFilter(PHPExcel_Reader_IReadFilter $pValue) {
                $this->_readFilter = $pValue;
        }

        public function loadIntoExisting($pFilename, PHPExcel $objPHPExcel)
        {
                // Check if file exists
                if (!file_exists($pFilename)) {
                        throw new Exception("Could not open " . $pFilename . " for reading! File does not exist.");
                }

                // Create new PHPExcel
                while ($objPHPExcel->getSheetCount() <= $this->_sheetIndex) {
                        $objPHPExcel->createSheet();
                }
                $objPHPExcel->setActiveSheetIndex( $this->_sheetIndex );

                // Open file
                $fileHandle = fopen($pFilename, 'r');
                if ($fileHandle === false) {
                        throw new Exception("Could not open file $pFilename for reading.");
                }

                // Loop trough file
                $currentRow = 0;
                $rowData = array();
                while (($rowData = fgetcsv($fileHandle, 0, $this->_delimiter, $this->_enclosure)) !== FALSE) {
                        ++$currentRow;
                        $rowDataCount = count($rowData);
                        for ($i = 0; $i < $rowDataCount; ++$i) {
                                $columnLetter = PHPExcel_Cell::stringFromColumnIndex($i);
                                if ($rowData[$i] != '' && $this->_readFilter->readCell($columnLetter, $currentRow)) {
                                        // Unescape enclosures
                                        $rowData[$i] = str_replace("\\" . $this->_enclosure, $this->_enclosure, $rowData[$i]);
                                        $rowData[$i] = str_replace($this->_enclosure . $this->_enclosure, $this->_enclosure, $rowData[$i]);

                                        // Set cell value
                                        $objPHPExcel->getActiveSheet()->setCellValue(
                                                 $columnLetter . $currentRow, $rowData[$i]
                                        );
                                }
                        }
                }

                // Close file
                fclose($fileHandle);

                // Return
                return $objPHPExcel;
        }

        public function getDelimiter() {
                return $this->_delimiter;
        }

        public function setDelimiter($pValue = ',') {
                $this->_delimiter = $pValue;
                return $this;
        }

        public function getEnclosure() {
                return $this->_enclosure;
        }

        public function setEnclosure($pValue = '"') {
                if ($pValue == '') {
                        $pValue = '"';
                }
                $this->_enclosure = $pValue;
                return $this;
        }

        public function getLineEnding() {
                return $this->_lineEnding;
        }

        public function setLineEnding($pValue = PHP_EOL) {
                $this->_lineEnding = $pValue;
                return $this;
        }

        public function getSheetIndex() {
                return $this->_sheetIndex;
        }

        public function setSheetIndex($pValue = 0) {
                $this->_sheetIndex = $pValue;
                return $this;
        }
}