I need to scrap and parse some data from webpage to excel and daily have the value parsed up to date
I have a file as :
Pcs Available and if <10(red) 11 to 15 (yellow) , 16 to 20 (green)
I need to open the link on "A" copy the price on the page and Paste on "B" then copy the value on page <span id="JS_topStoreCount"></span> and paste on "C" if the number return below 10 cell color red if 11 to 15 color Yellow and 16 to 20 color green
If the <span id="JS_topStoreCount"></span> doesn't exist on the page has to return the value of "0" as well as if the purchase button <div class="buyBtn"> on the page doesn't exist has to return value "0"
MUST be compatible Windows/Mac machine and has to repeat the same to all the rows and daily update.
If you willing to offer only the Windows solution please avoid beat the project as I already have one
Please don't beat if you have no knowledge with MAC or if you never done similar project before .
11 freelancers are bidding on average $147 for this job
I'm expert in MS Word 2007, MS Excel, MS PowerPoint. I'm also familiar with copy editing and pdf editing with best tools and web scraping, web researching.
Hi, I can do this using python, the script can be executed on both mac and windows (and linux, etc.) after intalling python. I have written some scrapping projects like this using python with no problem.