Page 1 of 1

php to excel update

Posted: Thu Aug 24, 2006 2:17 am
by hazeld0g
I have an excel file already built and formatted and was hoping to use it as a template somehow and use php to update the template by pulling values from mysql. Problem is that I don't know if, or how, I can use the preexisting excel file to update the approperate cells with the values gathered by php from mysql. To give you an idea of the excel file you can look at it here...here As you can see, all I would want updated would be the names and the times of which they start

Thank you in advance for all your help!
Hazeld0g

Posted: Thu Aug 24, 2006 3:21 am
by jamiel
I am not sure how you can edit pre-existing Excel Spreadsheets. The way I would do it is always have a copy of my xls file as a csv, load that into PHP and use PEAR's Spreadsheet_Excel_Writer to generate a new Excel Spreadsheet each time after I have manipulateed my csv, and then obviously update the csv aswell.

However most of the time my bosses are more than capable of importing a csv to Excel so I doubt I would ever find the need to do this.