41 $this->doc_prop = array(
42 'Author' =>
'SimpleExcel',
43 'Company' =>
'SimpleExcel',
44 'Created' => gmdate(
"Y-m-d\TH:i:s\Z"),
45 'Keywords' =>
'SimpleExcel',
46 'LastAuthor' =>
'SimpleExcel',
60 <Row ss:AutoFitHeight="0">';
62 foreach($values as $val){
73 $datatype = is_string($val) ?
'String' : (is_numeric($val) ?
'Number' :
'String');
77 $value = filter_var($value, FILTER_SANITIZE_SPECIAL_CHARS);
80 <Cell><Data ss:Type="'.$datatype.
'">'.$value.
'</Data></Cell>';
93 $content =
'<?xml version="1.0"?> 94 <?mso-application progid="Excel.Sheet"?> 95 <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 96 xmlns:o="urn:schemas-microsoft-com:office:office" 97 xmlns:x="urn:schemas-microsoft-com:office:excel" 98 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 99 xmlns:html="http://www.w3.org/TR/REC-html40"> 100 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">';
102 foreach($this->doc_prop as $propname => $propval){
104 <'.$propname.
'>'.$propval.
'</'.$propname.
'>';
108 </DocumentProperties> 109 <Worksheet ss:Name="Sheet1"> 110 <Table>'.$this->tabl_data.
' 124 if(!is_array($values)){
125 $values = array($values);
127 $this->tabl_data =
"";
130 foreach ($values as $value) {
143 $this->doc_prop[$prop] = $val;
saveString()
Get document content as string.
setData($values)
Set XML data.
addRow($values)
Adding row data to XML.
setDocProp($prop, $val)
Set a document property of the XML.