Cerrado

automate a process between 2 excel files using winautomation software

This is a project for experts with experienced with software named WinAutomation.

we need constantly to updated our ads prices on a portal of online sales, then we need make it bulk by downloading an Excel file (file A) directly from the portal and make massive changes, these prices are updated by taking the price of a Excel file we already have (file B) and afterwards then upload the file (A) back to the sales portal.

We need a script to automate the above process, such as I describe below:

1) log in to the sales portal with our user name and password, and download from there the Excel file (file A) with the prices.

2) Open both Excel files and update the prices of products taking this information from the worksheets Excel workbook (File B) by searching all the worksheets and update the Excel file (File A) save it and then upload to the site.

The Excel file (File A) is downloaded from the Internet and has a single sheet with information located:

Product Name: Column C, starting at C4

Product price: Column F, starting at F4

The Excel file (File B) is always in our pc and has several worksheets but always the information is located:

Product Name: Column E, starting at E7

Prodcut price: Column AS, starting at the AS7

This update should be performed by searching AND comparing the existing product names of the products.

The application must be in the ability to search all the pages of Excel file (File B)

SPECIAL NOTE:

1)FREELANCER must to send us the flowchart and algorithm before starting to verify that the information is clear between both.

2)FREELANCER should include error handle programming

3)FREELANCER must to test several times by hisself before sending the project to ensure us everything is working out

Habilidades: Excel, HTML, Extracción de datos web

Ver más: working online as a freelancer, working as a freelancer in the us, us freelancer portal, starting as a freelancer, software sales freelancer, software freelancer portal, searching algorithm in c, searching algorithm, programming flowchart, process freelancer, need experts in excel, log out from freelancer, log in to freelancer, it project portal freelancer, freelancer test software, freelancer test excel, freelancer software programming, freelancer software price, freelancer portal 11, freelancer pc site

Información del empleador:
( 21 comentarios ) Bogota, Colombia

Nº del proyecto: #8838034

5 freelancers están ofertando el promedio de $129 para este trabajo

mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD en 5 días
(145 comentarios)
6.8
PigtailXL

Hello Sr., how are you ? Jorge is my name and I have wide experience using WinAutomation. Here you can take a look at a script built by me: [login to view URL] also this other about to scrape Más

$170 USD en 5 días
(64 comentarios)
5.9
haovo

hi, I will use C# winform and embedded a webbrowser to do these automated actions. I have built many bots like this one. Please refer my profile if you want to have more information. C# and embed webbrowser to lo Más

$133 USD en 3 días
(5 comentarios)
3.6
ITExportServices

Hi I have 15+ years experience in web scraping .so i can do easily. Please send me a more details so i can start your project ASAP. Thanks

$49 USD en 3 días
(6 comentarios)
3.7
mrdait

Hello sir i can achieve your project perfectly and without using "winautomation" my solution will be fast and efficiency if you are interested by my proposal i guarantee to you a perfect application that can extra Más

$50 USD en 3 días
(0 comentarios)
0.0
sherilu

I am a Data Entry/Data Processing Expert with years of experience. I also have experience in word and excel. PDF to Word and Excel.

$40 USD en 3 días
(0 comentarios)
0.0