Re: PHP excel capability

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jonathan Kahan wrote:
> Can PHP be used to generate an excel file that A) Contains Macros B)
> Allows Graphics to be attached C) where cells can contain borders as
> well as cells being merged. I know there is some PHP excel functionality
> so i am assume basics like underlines, italics and i am hoping vertical
> alignments can be done.
> 
> If the answer is no, then can a template that has all of these be opened
> and read using php where all that needs to be done is simply place in
> certain cells whatever values it is that I want to place.
> 
> Lastly, do only newer versions of PHP contain excel/pdf functionality?
> 
> I am in a bit of a time crunch so I apologize if this is not considered
> PHP stuff or if I could have found my answer easily online. I could not
> find this discussed in any other posts. Thanks in advance for any help
> you can give.

There is a pear module that can do some degree of Excel tinkering but
I've not had much success with it in the past.
http://pear.php.net/package/Spreadsheet_Excel_Writer

While I've not idea what it is, looking on Pear just now I see:
http://pear.php.net/package/Structures_DataGrid_Renderer_XLS which leads
to http://pear.php.net/package/Structures_DataGrid not sure if either
are what you need but I think I'll have a look at using it ;)

Also Excel is quite good at loading HTML pages with tables in them....
loads up nicely with font styles etc. colspan and rowspan (in html
tables) are supported etc.

All it requires is the "html" to be served up with the correct mime type
and Excel will load it up.

Create a sample spreadsheet in Excel which meets your needs and export
it as HTML and then use that as a basis to write your script.

I doubt very much if it will support macros, but you can suck it and see.

Let me know if you want more info as I have done this before.

Col.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux