[thelist] PHP .xls export

Judah McAuley judah at wiredotter.com
Sat Feb 25 15:05:36 CST 2006


I was not aware of the html table trick, that's pretty cool. Also, fwiw, 
border="1" did show up correctly when I opened the file in both 
OpenOffice 2.0 and Excel 2003.

Something to keep in the back of my brain for later.

Judah

Rick den Haan wrote:
> Matt,
> 
> Copy/pasted that table into a blank text file, renamed it .XLS and opened it
> in both Excel and OpenOffice.org, and you're right, it works.
> 
> However, [on my machine] Excel removes *all* the borders from the worksheet.
> When specifying <table border="1"> there's a border around the used cells
> only.
> 
> It's not that big an issue, but it's an issue nonetheless...
> 
> Rick.
> 
> On 2/25/06, Matt Warden <mwarden at gmail.com> wrote:
>> Yes, I am 99% sure you can use an HTML table and it will import
>> correctly into Excel. e.g.:
>>
>> <table>
>> <tr><td><b>Something:</b></td><td>99.83</td></tr>
>> <tr><td><b>Something:</b></td><td>99.83</td></tr>
>> <tr><td><b>Something:</b></td><td>99.83</td></tr>
>> </table>





More information about the thelist mailing list