Posted By

stavelin on 10/08/08

Tagged

php
excel

Versions (?)

Last Edited at 10/08/08 11:31am

Statistics

Viewed 2929 times

Favorited by 15 user(s)

Related snippets

Easy Excel export from PHP

/ Published in: PHP

This is saved from Gerhard Slettens weblog www.gersh.no. I just want yo keep it on snipplr so it easily can be fetched through textmate.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
header("Expires: 0");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
header("Content-type: application/vnd.ms-excel;charset:UTF-8");
header("Content-Disposition: attachment; filename=filename.xls"); 
print "\n"; // Add a line, unless excel error..
?>
<table border="1">
<tr>
<th>header 1</th>
<th>header 2</th>
</tr>
<tr>
<td>data 1</td>
<td>data 2 - nordic letters Ã¦, Ã¦, Ã¥</td>
</tr>
</table>