how to create new tabs/perform functions on excel using php?
Posted: Wed Apr 22, 2009 2:10 pm
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
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