Re: export data to a ms excel file using php

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