SimpleExcel\Writer\XMLWriter Class Reference

Inheritance diagram for SimpleExcel\Writer\XMLWriter:

Collaboration diagram for SimpleExcel\Writer\XMLWriter:

Public Member Functions
	__construct ()
	addRow ($values)
	Adding row data to XML. More...
	saveString ()
	Get document content as string. More...
	setData ($values)
	Set XML data. More...
	setDocProp ($prop, $val)
	Set a document property of the XML. More...
Public Member Functions inherited from SimpleExcel\Writer\BaseWriter
	__construct ()
	addRow ($values)
	Adding row data to table. More...
	saveString ()
	Get document content as string. More...
	saveFile ($filename, $target=NULL)
	Export the document. More...
	setData ($values)
	Set tabular data. More...

Protected Attributes
	$content_type = 'application/xml'
	$file_extension = 'xml'
Protected Attributes inherited from SimpleExcel\Writer\BaseWriter
	$tabl_data
	$content_type = 'text'
	$file_extension = 'txt'

Private Attributes
	$doc_prop

Detailed Description

Definition at line 11 of file XMLWriter.php.

Constructor & Destructor Documentation

__construct()

SimpleExcel\Writer\XMLWriter::__construct

(

)

Returns

void

Definition at line 40 of file XMLWriter.php.

                                 {
        $this->doc_prop = array(
            'Author' => 'SimpleExcel',
            'Company' => 'SimpleExcel',
            'Created' => gmdate("Y-m-d\TH:i:s\Z"),
            'Keywords' => 'SimpleExcel',
            'LastAuthor' => 'SimpleExcel',
            'Version' => '12.00'
        );
    }

Member Function Documentation

addRow()

SimpleExcel\Writer\XMLWriter::addRow

(

$values

)

Adding row data to XML.

Parameters

array

$values

An array contains ordered value for every cell

Returns

void

Implements SimpleExcel\Writer\IWriter.

Definition at line 57 of file XMLWriter.php.

References $row, and SimpleExcel\Writer\BaseWriter\$tabl_data.

Referenced by SimpleExcel\Writer\XMLWriter\setData().

                                   {
        $row = &$this->tabl_data;
        $row .= '
    <Row ss:AutoFitHeight="0">';

        foreach($values as $val){
            
            $value = '';
            $datatype = 'String';
            
            // check if given variable contains array
            if(is_array($val)){
                $value = $val[0];
                $datatype = $val[1];
            } else {
                $value = $val;
                $datatype = is_string($val) ? 'String' : (is_numeric($val) ? 'Number' : 'String');
            }
            
            // escape value from HTML tags
            $value = filter_var($value, FILTER_SANITIZE_SPECIAL_CHARS);
            
            $row .= '
    <Cell><Data ss:Type="'.$datatype.'">'.$value.'</Data></Cell>';
        }

        $row .= '
    </Row>';
    }

Here is the caller graph for this function:

saveString()

SimpleExcel\Writer\XMLWriter::saveString

(

)

Get document content as string.

Returns

string Content of document

Implements SimpleExcel\Writer\IWriter.

Definition at line 92 of file XMLWriter.php.

                                {
        $content = '<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">';
 
        foreach($this->doc_prop as $propname => $propval){
            $content .= '
  <'.$propname.'>'.$propval.'</'.$propname.'>';
        }
 
        $content .= '
 </DocumentProperties>
 <Worksheet ss:Name="Sheet1">
  <Table>'.$this->tabl_data.'
  </Table>
 </Worksheet>
</Workbook>';
        return $content;
    }

setData()

SimpleExcel\Writer\XMLWriter::setData

(

$values

)

Set XML data.

Parameters

array

$values

An array contains ordered value of arrays for all fields

Returns

void

Implements SimpleExcel\Writer\IWriter.

Definition at line 123 of file XMLWriter.php.

References SimpleExcel\Writer\XMLWriter\addRow().

                                    {
        if(!is_array($values)){
            $values = array($values);
        }
        $this->tabl_data = ""; // reset the xml data.

        // append values as rows
        foreach ($values as $value) {
            $this->addRow($value);  
        }
    }

Here is the call graph for this function:

setDocProp()

SimpleExcel\Writer\XMLWriter::setDocProp	(		$prop,
			$val
	)

Set a document property of the XML.

Parameters

string	$prop	Document property to be set
string	$val	Value of the document property

Returns

void

Definition at line 142 of file XMLWriter.php.

                                           {
        $this->doc_prop[$prop] = $val;
    }

Field Documentation

$content_type

SimpleExcel\Writer\XMLWriter::$content_type = 'application/xml'

protected

Definition at line 19 of file XMLWriter.php.

$doc_prop

SimpleExcel\Writer\XMLWriter::$doc_prop

private

Definition at line 35 of file XMLWriter.php.

$file_extension

SimpleExcel\Writer\XMLWriter::$file_extension = 'xml'

protected

Definition at line 27 of file XMLWriter.php.

---

The documentation for this class was generated from the following file:

• Modules/DataCollection/libs/SimpleExcel/Writer/XMLWriter.php