Using PHP to create MS Excel Sheets
Posted on 2004-11-18
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.