Output & in MS-excel using PHP

[eluser]thePiet[/eluser]
Well, I haven't got any experience with this kind of exporting to Excel, I always echo a plain HTML table to some file and give it a .xls extension.

Something like

Code:

<table>
<tr>
<td>Hello</td>
<td>World</td>
</tr>
</table>

Saved as a .xls file is displayed perfectly in Excel.

But again, your problem is other characters than alphanumeric, because of the headers. A plain "&"-sign is simply recognized as a field name in headers.

Good luck,

thePiet