[thelist] PHP .xls export

Matt Warden mwarden at gmail.com
Sat Feb 25 13:12:08 CST 2006


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rick den Haan wrote:
> Hey all,
> 
> Can anybody recommend a PHP class that allows me to export to the Microsoft
> Excel .XLS file format? Requirement: I need to be able to format contents
> (in particular I need to be able to make items bold)
> 
> I've found lots of classes that allow me to output unformatted data to
> Excel, but the only one that could output bold items uses a PEAR module.
> Unfortunately, my client's server does not have the PEAR extension to PHP
> installed, and server admins have informed me that installing it is not an
> option.
> 
> I could use CSV output, but AFAIK that format does not support formatting...
> 
> Any ideas?

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>

- --
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFEAKwIrI3LObhzHRMRAn3RAJ0ayBVMACw3azQERP0y8HAW2+SQ+gCgrE7s
65MQYrlpu8Z79AaaS4QH8n4=
=plrp
-----END PGP SIGNATURE-----



More information about the thelist mailing list