[thelist] Formatting cells in Excel from HTML/PHP

[Joe Lance]

Try biffWriter. http://www.web-aware.com/biff/

It should meet all your needs and is php based.
Just starting using it myself, its pretty slick.

HTH,
Joe

-----Original Message-----
From: Anthony Baratta [mailto:Anthony at Baratta.com]
Sent: Sunday, March 09, 2003 9:22 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Formatting cells in Excel from HTML/PHP


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

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !