Hi All,
Iam new to php. In my php application i would like to create/update excel worksheets using php code. here i need to fetch the data from mysql database and then i have to insert into excel sheet on daily basis. The next day same procedure happens and this time i have to update the data into second worksheet of same excel sheet.
Would appreciate if you guys can tell me on
1)how to create new tabs in excel worksheet and then
2)how to insert images into excel worksheet using phpcode and then
3)how to perform functions like sum,subtraction operations on the data using php code..
Thanks in advance.
Thanks,
krishna.p
how to create new tabs/perform functions on excel using php?
Moderator: General Moderators
Re: how to create new tabs/perform functions on excel using php?
I have played with extracting data from an excel file using PHP (using phpExcelReader) but never inserting it...
Though it will depend on the version of excel file you are using - Excel 2003 uses .xls where as Excel 2007 uses XML files.
Not having tried it - I would imagine that updating the XML files is relatively straight forward...
Though it will depend on the version of excel file you are using - Excel 2003 uses .xls where as Excel 2007 uses XML files.
Not having tried it - I would imagine that updating the XML files is relatively straight forward...
-
Mark Baker
- Forum Regular
- Posts: 710
- Joined: Thu Oct 30, 2008 6:24 pm