www.gopi.com@xxxxxxxxx wrote:
> Hi,
>
> I have tried your MS-Excel MIME type in PHP. But am facing a small problem. I can't get the grid lines as look like in normal Excel file.
>
> Am using windows XP, Internet explorer 6.0, MS Excel 2003
>
> Thanks in advance.-- Jim Lucas wrote :
> 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.
>
You could change this line
echo '<table>';
to this
echo '<table border="1">';
This will give you borders around your content at least.
Example:
http://www.cmsws.com/examples/php/testscripts/www.gopi.com@xxxxxxxxx/0001.php
I would checkout phpexcel also
--
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
