Using PHP to create MS Excel Sheets

Hi everyone,
Just needed some help with php. Let me get straight to the point, I need to figure out how to create excel sheets in php so that users who come to my site enter in some info, I thenmake the sheet for them and create a link for them to download the excel sheet. I will also probably need to implement sessions to delete the old excel sheets. Anyways I have no idea how to create excel sheets in php and was wondering if anybody could help me figure out how to do so.

I need to be able to:
1)  enter in specific data into certain fields
2)  format the cells (ie. show as percent instead of decimal)
3)  add styles to specific cells (ie. bg colour, fonts, alignment, etc.)

This site is generally going to be used to help University students create personal Grade calculators where they enter in the number of assignments/tests/reports they have, what mark they recieved in each (blank for those not yet recieved/done), what mark they would like to get. Based on this info the sheet will display what marks they need to get to recieve their desired final and what mark they would get if they get perfect in the unmarked sections. Also it will tell them what their current mark is.

I have already created a template sheet (with formulas) which I am using for my own marks and hope to use that as a guide for my site.
popnfresh86Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hernst42Commented:
See http://pear.php.net/package/Spreadsheet_Excel_Writer
I use it to create such xls-files. What you can't do is edit an exisiting xls-file, but you can create formulars, text, formating, ..

If you use a windows-server you might use COM to access excel and modify your xls-files.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compustarsgCommented:
one more way is you can create csv (comma seperated)  files using php, which you can open in ms excel. but you cant do formating, coluring etc., may be some way but i dont know.
0
Codeit1978Commented:
I found this site where it creates the excel file from a SQL database.
You may want the users to enter in the data save it to the SQL database and then generate the spead sheet and prompt the user to download.

This url shows you how to create a excel spread sheet from a SQL database.

http://www.stargeek.com/php_scripts.php?script=2&PHPSESSID=abddb1bbe251144cf84109b93ea06ed1
0
popnfresh86Author Commented:
Thanks for the suggestions. hernst42 gets the points cuz it was more of what i was looking for. Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.