Why doesn't this work?

harlowhair

I am trying to display an an excel spreadsheet using the following method:

<?php
header("Content-type: application/ms-excel");
?>
print("<table>
<tr>
<td>1</td>
<td>t</td>
</tr>
<tr>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td colspan="2">=SUM(A1;B2)</td>
</tr>
</table>

The output I get is just as if I'd not bothered sending the header. I need to display the results as an excel file because my employers get very excited about that sort of thing.
Thanks

viper21634

Well you need to go back and reread your php book

your code:

<?php 
header("Content-type: application/ms-excel"); 
?> 
print("<table> 
<tr> 
<td>1</td> 
<td>t</td> 
</tr> 
<tr> 
<td>3</td> 
<td>4</td> 
</tr> 
<tr> 
<td colspan="2">=SUM(A1;B2)</td> 
</tr> 
</table>

what it needs to be

<?php 
header("Content-type: application/ms-excel"); 
?> 
<html>
<body>
<table> 
<tr> 
<td>1</td> 
<td>t</td> 
</tr> 
<tr> 
<td>3</td> 
<td>4</td> 
</tr> 
<tr> 
<td colspan="2"><?php =SUM(A1;B2) ?></td> 
</tr> 
</table> 
</body>
</html>

harlowhair

With this code i get a parse error on the line containing the
=SUM(A1;B2)
With my previous code, only an html table was displayed. Are ther enay more headers I need to send? I've tried setting the content disposition to inline and attachment but this does not work. The only reason I am trying to do this this way, is that the server I am using (not by choice) doesn't support COM objects. My usual method of choice would be to create an xls file, and then use readfile() to view it. Any other suggestions?

viper21634

I am not sure that you can even send a xsl file to a browser, in fact inless the users system has office/excel. they cant view it, what you need to do is to open the file, then parse it into a array, then you should be able to work with it as you need to