[thelist] Formatting cells in Excel from HTML/PHP

[Anthony Baratta]

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
>manually.

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
solution.

         http://excelwriter.softartisans.com/default.aspx?PageID=8

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

"Conformity is the refuge of the unimaginative."