[thelist] Formatting cells in Excel from HTML/PHP

Anthony Baratta Anthony at Baratta.com
Sun Mar 9 11:19:01 CST 2003

At 09:08 AM 3/9/2003, Andrew Finger wrote:

>Is there a way to format cells in an Excel spreadsheet created through a web
>page driven with PHP code?  I've generated the spreadsheet, but I'd like to
>format cells for currency and align other cells with the decimal point to
>make the spreadsheet pleasing to the eye.  So, for instance, does anyone
>know if there is a cell-by-cell command I can type to format each cell?
>This way I could automate the formatting in the web page and not do it

Not unless you can write a binary compatible Excel file. I've had success
with an Excel COM object from Software Artisans, but that is a Windows only


I don't know of any other solution out there.
Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list