Completado

Need Simple PHP / Excel Script Created To Strip Data From a Column Into Another Column (No Database)

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.

Habilidades: PHP

Ver más: will i get data entries from us or uk to work from home, what do i need to start php programming, need to build custom excel model in new delhi, i need to create an excel consultant sydney, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne, i have 300 names in excel file need to done copy from excel file into notepad file, data converter from dwg andor dxf to shp gdb kml, data entry excel online database, bulk data entry excel database, online excel database data entry, send data html excel php, sample excel database data entry form, excel database data entry form, data entry excel database, excel database data entry, hoe data form excel sheet write database perl, data export excel php button, rearrange database data excel, import data database via odbc excel using vba

Información del empleador:
( 58 comentarios ) Tarpon Springs, United States

Nº del proyecto: #12062286

Adjudicado a:

RITESHBATHWAL

Hello Sir, I have read your full description and I will finish the work withing 4 hours. I got the idea that you need value of a row in Column A to be copied into the Column C based on the condition if the value of the Más

$90 USD en 1 día
(182 comentarios)
6.6

12 freelancers están ofertando el promedio de $121 para este trabajo

rambanstola

will be ready latest tomorrow morning

$111 USD en 0 días
(63 comentarios)
5.7
vedaantTech

Hello there, I have reviewed your job description as well and very confident to handle this project perfectly. I am expert in Web designing/developing.I believe that I can be the best productive candidate for this requ Más

$100 USD en 3 días
(29 comentarios)
5.8
eiliasolutions

Hi, There. Greetings from EiliaSolutions. Pleased to submit the proposal for your PHP Script. I am working on web development for over 9 years including Wordpress, PHP, Java, JavaScript, HTML etc. Please have Más

$100 USD en 2 días
(23 comentarios)
4.7
gracefulwork

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/.

$100 USD en 1 día
(50 comentarios)
5.1
patidaryogesh

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

$111 USD en 3 días
(16 comentarios)
4.5
siddhu5tech

Hello, my name is siddhartha i have 4years experience in web app develoopent. i went through the description and i can deliver in in 4 hours with a script which process the xls file and gives you desired output. i can Más

$100 USD en 1 día
(8 comentarios)
3.7
$155 USD en 3 días
(6 comentarios)
2.8
$155 USD en 3 días
(1 comentario)
1.2
websas

NO LIKE NO PAY | 100% SATISFACTION GUARANTEE We want to have long term relations with our clients that's why working at very good prices. Hope you will give us a chance to prove ourselves. Money is also not an issue w Más

$250 USD en 3 días
(1 comentario)
0.0
$110 USD en 2 días
(0 comentarios)
0.0
anson418

If you're willing to settle for a command line tool in Python I can deliver it by the deadline at a respectable discount over the $100. Unfortunately I don't have the existing knowledge of PHP-xls/x interaction to do Más

$75 USD en 1 día
(0 comentarios)
0.0