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
