Hello every one .
I need some one to extract data from and Excel sheet .. add them to MYSQL database .. and then regenerate a similar excel sheet with the old data and other data as stats from the database .
This should be a simple task ..and I ONLY pay after I make sure that the task is done accurately and in time .I will also have a look at the code .So what shall be done is exactly the following :
- Upload an Excel sheet to my website through a form .
- Create a function that reads all the data from that Excel sheet and returns it as an array .
- loop through this array and add data to a MYSQL database table .
- Do some calculations on the saved data .. and then regenerate a similar excel sheet to the one just uploaded but with extra two columns filled with the cacluated data (Percentage and evaluation columns)... Percentage data is calculated based on grades .. I will provide more to the winner .
- There shall be a link to download the generated excel file at the end .
That's it .
As I said simple job .. I could do that my self .. But I just donot have time to .
Your code shall be commented .
Please check the attached excel sheet .
Also please mention "ExcelSheet" to make sure you read the post till the end.