[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
>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."
More information about the thelist
mailing list