Location: PHPKode > scripts > Excel XML Parser > excel-xml-parser/ExcelXMLWorksheet.php
<?php
/*
* ============================================================================
*
* @name ExcelXMLWorksheet.php
*
* @author andrew.aculana
* @version 2.0
* @license	http://opensource.org/licenses/gpl-license.php GNU Public License
* @date 2006-07-03
*
* ============================================================================
*
* License:	GNU Lesser General Public License (LGPL)
*
* Copyright (c) 2004 LINK2SUPPORT INC.  All rights reserved.
*
* This file is part of the L2S Online Application Framework
*
* 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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*
* ============================================================================
*/

/**
 * @package ExcelXMLParser
 * @subpackage ExcelXMLParser
 */
 	
include_once 'ExcelXMLTable.php';

class ExcelXMLWorksheet{
	
	/**
	 * Excel XML Worksheet Attributes
	 * @var String $Name
	 * @var Table $Table
	 * @var Associative Array $data
	 * @var Integer $Encoding
	 */
	var $Name;
	var $Table;
	var $data;
	var $Encoding;
#-----------------------------------------------------------------------------#

	/**
	 * class constructor - initialize attributes
	 * 
	 * @author Andrew A. Aculana
	 * @version 2.0
	 * @copyright 2006-07-03
	 * @return null
	 */
	function ExcelXMLWorksheet(&$Data,$Encoding){
		$this->Table		  = new ExcelXMLTable($Data['children']['Table'],$Encoding);
		$this->Name      	  = "";
		$this->data			  =& $Data;
		$this->Encoding		  =& $Encoding;
	}
#-----------------------------------------------------------------------------#

	/**
	 * set the worksheet name
	 * 
	 * @author Andrew A. Aculana
	 * @version 2.0
	 * @copyright 2006-07-03
	 * @param String $Name
	 * @return null
	 */
	function setName($Name = ""){
		if(isset($this->data['attrs']['ss:Name'])){
			$this->data['attrs']['ss:Name'] = $Name;
		}elseif(isset($this->data['attrs']['Name'])){
			$this->data['attrs']['Name'] = $Name;
		}else{
			/* unknown worksheet format */
		}
		$this->Name = $Name;
	}
#-----------------------------------------------------------------------------#

	/**
	 * get worksheet name
	 * 
	 * @author Andrew A. Aculana
	 * @version 2.0
	 * @copyright 2006-07-03
	 * @return String
	 */
	function getName(){
		if(isset($this->data['attrs']['ss:Name'])){
			return $this->data['attrs']['ss:Name'];
		}elseif(isset($this->data['attrs']['Name'])){
			return $this->data['attrs']['Name'];
		}else{
			/* unknown worksheet format */
			return "";
		}
		return $this->Name;
	}
#-----------------------------------------------------------------------------#
}
?>
Return current item: Excel XML Parser