Using php to create XML file

[Nodral]

Hi all

 

I'm trying to create an XML file to be used within Excel.  The data is drawn dynamically from my database depending on the information supplied by the user.

 

However when I run it, I get a complain from Excel about some missing whitespace.

 

any ideas?

 

<?php
$output='<?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">
  <Author>Europcar</Author>
  <LastAuthor>Europcar</LastAuthor>
  <Created>2011-10-28T10:48:37Z</Created>
  <Company>Europcar</Company>
  <Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>11760</WindowHeight>
  <WindowWidth>15195</WindowWidth>
  <WindowTopX>480</WindowTopX>
  <WindowTopY>75</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
</Styles>
<Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="'.$columns.'" ss:ExpandedRowCount="'.($count+5).'" x:FullColumns="1"x:FullRows="1">';
	   //$output.='<Column ss:AutoFitWidth="0" ss:Width="50"/>/n';
   
   $output.='<Row>';
   foreach ($titles as $value){
   if(is_numeric(substr($value,0,1))){
	   $value=substr($value,1);
   }
   $output.='<Cell><Data ss:Type="String">'.$value.'</Data></Cell>'."LF";
   
   }
   /*$output.='</Row>';
        foreach ($dataOut as $value){
	  $output.='<Row>';
	  foreach($value as $values){
		  if(strlen($values)<1){
			  $values=" ";
		  }
		$output.= '<Cell><Data ss:Type="String">'.$values.'</Data></Cell>';
   }
   $output.='</Row>';
   }*/
   $output.='
    </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>'.($count+5).'</ActiveRow>
 <ActiveCol>'.$columns.'</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
</Worksheet>
</Workbook>';