how to create new tabs/perform functions on excel using php?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
krishna.p
Forum Newbie
Posts: 19
Joined: Fri May 23, 2008 8:12 am

how to create new tabs/perform functions on excel using php?

Post by krishna.p »

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
philln
Forum Newbie
Posts: 12
Joined: Thu Apr 23, 2009 9:22 am

Re: how to create new tabs/perform functions on excel using php?

Post by philln »

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...
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: how to create new tabs/perform functions on excel using php?

Post by Mark Baker »

Take a look at PHPExcel
Post Reply