[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