PHPExcel to Mysql
$30-250 USD
Paid on delivery
PLEASE DO NOT BID UNLESS YOU READ ALL THE PROJECT AND YOU FULL UNDERSTAND IT
This project consists mainly of data manipulation.
It will be necessary to write a script that will choose a *xlsx file from a directory, based on a specific part of the file name.
After that, the script should call PHPExcel to add nonexistant rows to a MySql table.
After, the table should be presented as HTML5 (responsive way), with a date filter (choose month), and there should be a button in front of each row (edit button) that will open a popup window .
In this popup window, it will be possible to add some information to that row (add a few fields), and the possibility to mark this row as "validated" or "edited" or "rejected". When marked, the popup will close, and the "edit button" on front of the row will change color and lable to either "validated" or "edited" or "rejected".
When user decides that all lines/rows are edited, he should be able to generate a pdf report with validated rows, and this report should be emailed as an attach. After this step, this month should be considered as "closed" and it wont be possible to edit anymore. When closed the table within this date range (month) will only be available to view (not edit).
Everything will be done on [login to view URL], on a new separator of a site with already made user authentication system.
Project ID: #14997766
About the project
16 freelancers are bidding on average $227 for this job
Hi! I'm interesting your project very well. i mastering PHPEXCEL and MYSQL. And also I have many experience and good skill about web and android development. Let's go ahead with me
I am good in Website building and 5 years development experience. And I am experienced in Web development using Wordpress, Shopify, Woocmmerce Website building. I have a working experience in web user controls, ma More
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Hi i have read your full project requirement. I can parse your data using php with PHPExcel to process the .xlsx file. Next I can develop the page using bootstrap to make the page responsive and using bootstrap modal More
Hi, We are an established Company with experienced team since 2003 and our clients are spread in all over the sphere such as US, UK, Canada, Europe & other countries. We can self-assuredly provide you references of ou More
I understood the requirement. I worked on many excel automation projects ; please check my previous projects on profile page. I can make the required table interface from csv file and store changes into db . .please More