PHP Classes

File: ExcelXMLWorksheet.php

Recommend this page to a friend!
  Classes of Andrew Aculana   Excel XML Parser   ExcelXMLWorksheet.php   Download  
File: ExcelXMLWorksheet.php
Role: Class source
Content type: text/plain
Description: Worksheet Class
Class: Excel XML Parser
Read and write data to Excel XML worksheets
Author: By
Last change: Update Version 2.0
Date: 18 years ago
Size: 3,323 bytes
 

Contents

Class file image Download
<?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;
    }
#-----------------------------------------------------------------------------#
}
?>