abderrazzak nejeoui wrote:
> can you help me to export data to a ms excel file using php. i tried to
> export them to an html format and change the extension to .xls that's work
> but i have lost the formatting
>
> excel and the navigator doesn't interpret my code in the same why (celles
> are not in the same size)
>
Ok, so with the examples of others here, here is the shortest example that I came up with that
should get you going.
<?php
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
$x = $y = range(0, 12);
echo '<table>';
echo '<tr><td> </td><td>' . join('</td><td>', $x) . '</td></tr>';
foreach ( $x AS $xx ) {
echo "<tr><td>{$xx}</td>";
foreach ( $y AS $yy ) {
echo "<td>=sum(".(chr(ord('b')+$yy))."1*a".($xx+2).")</td>";
}
echo "</tr>";
}
echo '</table>';
?>
This will output a 14x14 table. It will calculate the totals for each cell in the actual
spreadsheet once excel loads it.
If you have any questions, ask away.
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
