I need an expert in PhpExcel for this work.
Step1: In a web control panel madein php the user would upload a file in csv format. When you upload this file you must make some changes in its content:
1- Order the table using 3 different columns.
2- Replace some values in one column.
3- Autofit all the columns. Later you must fix the width of some columns.
4- Inmobilize row1 with the header (like you could do in an Excel file).
5- Change the colour of the background of the header (only for cells with data) and use bold letters.
6- Change the colour of the background of the rest of cells with data.
We are going to call "[login to view URL]" the final file.
Step2: in the control panel the user would see 5 buttons.
Button1: Rename the file "[login to view URL]" to "[login to view URL]"
Button2: in "[login to view URL]" there's a column called ACTIVIDADES (activities). You must generate so many files like activities there are in that column. You must rename the name of each file with its activity name. Place all the files in a folder called "ACTIVIDADES". Be careful because it could happen that the file "[login to view URL]" has only 1 activity and then it's not necessary generate any file.
Button3: Rename the file "[login to view URL]" to "[login to view URL]". Place the file in a folder called "EMAILS". Then delete all the columns excepts one of them with emails. Too you must delete repeated emails in that column.
Button4: Using the files generated with button2 for every file you must delete all the columns excepts one of them with emails. Too you must delete repeated emails in that column. You must place the files generated in a new folder called "ACTIVIDADES" inside the folder "EMAILS".
Button5: This button makes a zip file with all the files and folders generated in step2.
If you have read all this project please insert that text "DATABASE" in your bid.
Dear Sir,
I am having more than 12 years experience of working as a web developer and having a great exposure of website Development in PHP, MySQL and jQuery.I believe in quality and client's satisfactions.I have also worked with PHPExcel. Please keep in mind it has a limitation on row numbers.
I am waiting for your most valuable conversations
Regards
Ajoy
hi
i am programmer i can program in php and java
you want to upload csv and output xlsx with some formating
i can do this task for you
lets us discuss more
DATABASE
Hi,
I can start on this work by now and complete in short time. I have 7 years of work experience in web development and can provide a good quality of work.
Hi
i am not individual but CEO of a firm where i have a team of developers. My PHP team of capable of meeting any challenge. currently we are making php module with auto video making. your task is what i want to do for my portfolio.
rest i can hope for the favor at your end.
Regards
Tooba