Subversion Repositories eFlore/Applications.cel

<?php

/**

 * PHPExcel

 *

 * Copyright (c) 2006 - 2013 PHPExcel

 *

 * This library is free software; you can redistribute it and/or

 * modify it under the terms of the GNU Lesser General Public

 * License as published by the Free Software Foundation; either

 * version 2.1 of the License, or (at your option) any later version.

 *

 * This library is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

 * Lesser General Public License for more details.

 *

 * You should have received a copy of the GNU Lesser General Public

 * License along with this library; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

 *

 * @category   PHPExcel

 * @package    PHPExcel

 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

 * @version    ##VERSION##, ##DATE##

 */

/**	PHPExcel root directory */

if (!defined('PHPEXCEL_ROOT')) {

	/**

	 * @ignore

	 */

	define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../');

	require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');

}

/**

 * PHPExcel_IOFactory

 *

 * @category   PHPExcel

 * @package    PHPExcel

 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 */

class PHPExcel_IOFactory

{

	/**

	 * Search locations

	 *

	 * @var	array

	 * @access	private

	 * @static

	 */

	private static $_searchLocations = array(

		array( 'type' => 'IWriter', 'path' => 'PHPExcel/Writer/{0}.php', 'class' => 'PHPExcel_Writer_{0}' ),

		array( 'type' => 'IReader', 'path' => 'PHPExcel/Reader/{0}.php', 'class' => 'PHPExcel_Reader_{0}' )

	);

	/**

	 * Autoresolve classes

	 *

	 * @var	array

	 * @access	private

	 * @static

	 */

	private static $_autoResolveClasses = array(

		'Excel2007',

		'Excel5',

		'Excel2003XML',

		'OOCalc',

		'SYLK',

		'Gnumeric',

		'HTML',

		'CSV',

	);

    /**

     *	Private constructor for PHPExcel_IOFactory

     */

    private function __construct() { }

    /**

     * Get search locations

     *

	 * @static

	 * @access	public

     * @return	array

     */

	public static function getSearchLocations() {

		return self::$_searchLocations;

	}	//	function getSearchLocations()

	/**

	 * Set search locations

	 *

	 * @static

	 * @access	public

	 * @param	array $value

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function setSearchLocations($value) {

		if (is_array($value)) {

			self::$_searchLocations = $value;

		} else {

			throw new PHPExcel_Reader_Exception('Invalid parameter passed.');

		}

	}	//	function setSearchLocations()

	/**

	 * Add search location

	 *

	 * @static

	 * @access	public

	 * @param	string $type		Example: IWriter

	 * @param	string $location	Example: PHPExcel/Writer/{0}.php

	 * @param	string $classname 	Example: PHPExcel_Writer_{0}

	 */

	public static function addSearchLocation($type = '', $location = '', $classname = '') {

		self::$_searchLocations[] = array( 'type' => $type, 'path' => $location, 'class' => $classname );

	}	//	function addSearchLocation()

	/**

	 * Create PHPExcel_Writer_IWriter

	 *

	 * @static

	 * @access	public

	 * @param	PHPExcel $phpExcel

	 * @param	string  $writerType	Example: Excel2007

	 * @return	PHPExcel_Writer_IWriter

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function createWriter(PHPExcel $phpExcel, $writerType = '') {

		// Search type

		$searchType = 'IWriter';

		// Include class

		foreach (self::$_searchLocations as $searchLocation) {

			if ($searchLocation['type'] == $searchType) {

				$className = str_replace('{0}', $writerType, $searchLocation['class']);

				$instance = new $className($phpExcel);

				if ($instance !== NULL) {

					return $instance;

				}

			}

		}

		// Nothing found...

		throw new PHPExcel_Reader_Exception("No $searchType found for type $writerType");

	}	//	function createWriter()

	/**

	 * Create PHPExcel_Reader_IReader

	 *

	 * @static

	 * @access	public

	 * @param	string $readerType	Example: Excel2007

	 * @return	PHPExcel_Reader_IReader

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function createReader($readerType = '') {

		// Search type

		$searchType = 'IReader';

		// Include class

		foreach (self::$_searchLocations as $searchLocation) {

			if ($searchLocation['type'] == $searchType) {

				$className = str_replace('{0}', $readerType, $searchLocation['class']);

				$instance = new $className();

				if ($instance !== NULL) {

					return $instance;

				}

			}

		}

		// Nothing found...

		throw new PHPExcel_Reader_Exception("No $searchType found for type $readerType");

	}	//	function createReader()

	/**

	 * Loads PHPExcel from file using automatic PHPExcel_Reader_IReader resolution

	 *

	 * @static

	 * @access public

	 * @param 	string 		$pFilename		The name of the spreadsheet file

	 * @return	PHPExcel

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function load($pFilename) {

		$reader = self::createReaderForFile($pFilename);

		return $reader->load($pFilename);

	}	//	function load()

	/**

	 * Identify file type using automatic PHPExcel_Reader_IReader resolution

	 *

	 * @static

	 * @access public

	 * @param 	string 		$pFilename		The name of the spreadsheet file to identify

	 * @return	string

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function identify($pFilename) {

		$reader = self::createReaderForFile($pFilename);

		$className = get_class($reader);

		$classType = explode('_',$className);

		unset($reader);

		return array_pop($classType);

	}	//	function identify()

	/**

	 * Create PHPExcel_Reader_IReader for file using automatic PHPExcel_Reader_IReader resolution

	 *

	 * @static

	 * @access	public

	 * @param 	string 		$pFilename		The name of the spreadsheet file

	 * @return	PHPExcel_Reader_IReader

	 * @throws	PHPExcel_Reader_Exception

	 */

	public static function createReaderForFile($pFilename) {

		// First, lucky guess by inspecting file extension

		$pathinfo = pathinfo($pFilename);

		$extensionType = NULL;

		if (isset($pathinfo['extension'])) {

			switch (strtolower($pathinfo['extension'])) {

				case 'xlsx':			//	Excel (OfficeOpenXML) Spreadsheet

				case 'xlsm':			//	Excel (OfficeOpenXML) Macro Spreadsheet (macros will be discarded)

				case 'xltx':			//	Excel (OfficeOpenXML) Template

				case 'xltm':			//	Excel (OfficeOpenXML) Macro Template (macros will be discarded)

					$extensionType = 'Excel2007';

					break;

				case 'xls':				//	Excel (BIFF) Spreadsheet

				case 'xlt':				//	Excel (BIFF) Template

					$extensionType = 'Excel5';

					break;

				case 'ods':				//	Open/Libre Offic Calc

				case 'ots':				//	Open/Libre Offic Calc Template

					$extensionType = 'OOCalc';

					break;

				case 'slk':

					$extensionType = 'SYLK';

					break;

				case 'xml':				//	Excel 2003 SpreadSheetML

					$extensionType = 'Excel2003XML';

					break;

				case 'gnumeric':

					$extensionType = 'Gnumeric';

					break;

				case 'htm':

				case 'html':

					$extensionType = 'HTML';

					break;

				case 'csv':

					// Do nothing

					// We must not try to use CSV reader since it loads

					// all files including Excel files etc.

					break;

				default:

					break;

			}

			if ($extensionType !== NULL) {

				$reader = self::createReader($extensionType);

				// Let's see if we are lucky

				if (isset($reader) && $reader->canRead($pFilename)) {

					return $reader;

				}

			}

		}

		// If we reach here then "lucky guess" didn't give any result

		// Try walking through all the options in self::$_autoResolveClasses

		foreach (self::$_autoResolveClasses as $autoResolveClass) {

			//	Ignore our original guess, we know that won't work

			if ($autoResolveClass !== $extensionType) {

				$reader = self::createReader($autoResolveClass);

				if ($reader->canRead($pFilename)) {

					return $reader;

				}

			}

		}

		throw new PHPExcel_Reader_Exception('Unable to identify a reader for this file');

	}	//	function createReaderForFile()

}