Thanks
You're the best! Got it working!!! Thanks a ton!
mcdermottmb
Last Activity: Feb 15 '08, 11:11 AM
Joined: Jan 23 '08
Location:
-
-
lets try this again----- Thanks for the reply. Will this technique work with a multi-sheet workbook as well? How would you go about inserting the variables; writing the XML line by line from PHP or passing variables to an XML page and echoing them? I have tried saving my workbook as XML and uploading to my webserver but it displays in the browser as raw text as opposed to opening up Excel. It is about 4500 lines of code if that matters. I have...Leave a comment:
-
Thanks for the reply. Will this work for multi-sheet workbooks too? Would you try to pass PHP variables into the template or write the XML dynamically, inserting values as you go? I am still relatively new to programming and have no experience at all with XML. When I save my workbook to xml, I get about 4500 lines of code. I have been searching for the syntax to insert PHP variables into the XML code and open the resulting document as a workbook...Leave a comment:
-
Thanks for the reply. Will this work for multi-sheet workbooks too? Would you try to pass PHP variables into the template or write the XML dynamically, inserting values as you go? I am still relatively new to programming and have no experience at all with XML. When I save my workbook to xml, I get about 4500 lines of code. I have been searching for the syntax to insert PHP variables into the XML code and open the resulting document as a workbook...Leave a comment:
-
Is it possible to write to an Excel template via PHP?
Is it possible to open a multi-sheet Excel template which resides on the webserver, populate it with data from a MySql query then save the spreadsheet to another folder and name on the webserver? The only classes I can find will create a new spreadsheet and populate it then open it for the user. I have a 10 sheet workbook with a substantial amount of formatting and a tremendous number of formulas that I would rather not have to duplicate in PHP...
No activity results to display
Leave a comment: