[PHP] Re: PHP excel capability
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
[PHP] Re:[PHP] excel 2 csv 2 mysql
Justin, For reading, you could try this: http://www.zakkis.ca/products/abc_excelparser/index.php Cost is 150 CAD - quite steep. Tried the online demo - seems to work. Will only work with cells containing strings though - doesn't resolve formulae. If you purchase it, perhaps you could let me know how you get on? For writing, there seems to be a module in Pear: http://pear.php.net/package-info.php?pacid=156 hi guys i am trying to work out how to dynamically be able to upload an excel file , export it to csv to be able to import into mysql , is there any examples out there ? fopen gave me binary code :| -- Geoff Caplan Advantae Ltd http://www.advantae.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP Excel
Have a look at my post of 17/05/2002, I got a lot of help from there. Bye, Evan Jean-Louis Letortorec [EMAIL PROTECTED] ha scritto nel messaggio 615315231286D21182E40008C7B1EED241EDF7@COMPAQ3000">news:615315231286D21182E40008C7B1EED241EDF7@COMPAQ3000... Hello every one: I'm trying to create XLS files on the fly. I found BiffWriter. Looks great for adding texts and numbers, but not formulas. Has anyone implemented something about formulas? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php