Hello, I need this script to be built, completed and tested within the next several hours. This is a very simple script that I need built and it requires no database and no design, you can just use plain text and a button if you want.
Here is what I need the script to do:
- The script will be inside of a directory. Upon accessing the directory the index file will open a page with a browse button on it. I will click the browse button and select an xls or xlsx file (the script must work with both file types) and then I will click on a button called process. Upon clicking on the process button the script will run in real time until it is complete. Upon completion the system will either prompt me to open/download the processed file or it will take me to a page where I can click a download link.
Here is what the script will process:
- Inside of the xls or xlsx file that I submit into the system there is only data in columns A and B. In column A, there is a list of UPC codes. In column B, most of the data is blank, but for some of the rows there is data which looks like this: B00WJ5JHOO (These are Amazon ASIN#'s). What I need for the script to do is output all of the UPC codes from Column A into Column C besides the UPC codes that have matches in column B. So if column B has data inside of it, then it will not be placed in Column C. If column B is blank then then that UPC code must go into column C. What we are trying to do is just strip any UPC codes that have matching data in Column B.
Inside of column C, the UPC codes must be in the same order as they are in column A and there must be no blank cells in between anywhere in column C at all.
Examples: (Please see file attachments)
Example file 1: Example file 1 shows what the file will look like that we upload.
Example file 2: Example file 2 shows what the completed file will look like after the script processes it.
Please note: When we are uploading files the script must be able to handle up to 100,000 rows of data when upload the xlsx files. I will also provide a sample file of 100,000 rows of data to the winner of the project so you can use that file for testing to ensure the script can handle it without breaking the script.
Please only bid if you can complete this script within the next 4 hours or less. We have a deadline to meet and it has to be completed within 4 hours or less. Also, when bidding make sure to leave a custom message with your bid so that we know that you understand the project description. Any copy/paste bidders will be ignored. Please bid $100 or less to be considered for this project. 100% milestone payment will immediately be loaded upon awarding the project.
If you have any questions regarding this project, please feel free to let me know and I can clarify.
12 freelancers están ofertando el promedio de $121 para este trabajo
Worked previously on excel sheet upload and produce same in output using phpexcel in my project https://www.freelancer.com/projects/php/Access-spreadsheet-content-via-database/.
Hi, I have reviewed your requirements and interested in doing this job. Actually i have already did this type of work previously and well know how to handle xls, xlsx files. Thanks