RE: MySQL to EXCEL?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





>>
>> I don't know how you have it setup.
>>
>> But you can create a XLS file on the fly using PHP....
>>
>> By using header...
>
>> header("Content-Type: application/vnd.ms-excel");
>> header("Content-Dispostion: attachemnt; filename='Project.xls'");
>> header("Pragma: no-cache");
>> header("Expires: 0");
>>
>>
>> Then just echo your results from your query, like normal...

> Could you expound on this?  What field delimiter are you using?

You can use
<table>
      <tr>
            <td>

and each tr becomes an excel row and each td becomes a cell.  This may or
may not work in/before excel97??

If you're looking to create true excel files, then i highly suggest
spreadsheetwrite_excel,
It is an excellent codeset, enabling you to use many features of excel such
as colors, math, formats, etc.

doing it this way, is little to no different from exporting in csv format,
but it does work
as described.

HTH
Jeff


>
>
> You have just created a XLS from PHP...Which can be saved to a XLS
> Workbook...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux