Page 1 of 1

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

Posted: Wed Apr 22, 2009 2:10 pm
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

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

Posted: Thu Apr 23, 2009 10:16 am
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...

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

Posted: Tue Apr 28, 2009 11:46 am
by Mark Baker
Take a look at PHPExcel