automate a process between 2 excel files using winautomation software

Closed Posted Nov 4, 2015 Paid on delivery
Closed Paid on delivery

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 Web Scraping

Project ID: #8838034

About the project

5 proposals Remote project Active Dec 11, 2015

5 freelancers are bidding on average $129 for this job

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 in 5 days
(145 Reviews)
6.8
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 More

$133 USD in 3 days
(5 Reviews)
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 in 3 days
(6 Reviews)
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 More

$50 USD in 3 days
(0 Reviews)
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 in 3 days
(0 Reviews)
0.0