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

Excel HTML Extracción de datos web

Nº del proyecto: #8838034

Sobre el proyecto