Jump to content

Web Scraping: From Excel to Web back to Excel


Recommended Posts

Hi Everyone, I'm a total newbie.

Can anyone guides me to the right tutorial. what I need to do is as follow:

1. Copy a URL from excel

2. Go to the web with that URL.

3. Highlight the data and copy it.

4. Paste to Excel.

It sounds easy, but would be hard for starter to write a script for that?

I'm now watching some of the beginner videos on YouTube. Please let me know what should I foucs on.

Many thanks!

Link to comment
Share on other sites

Welcome to AutoIt and the forum!

All Excel related stuff can be found in the Excel UDF that comes with AutoIt.

All web related stuff depends on the browser you use. AutoIt comes with an UDF for Internet Explorer. For FF and Chrome you'll find UDFs on the forum.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

I think Waters Excel UDF and the Autoit IE UDF will be your best friends for this.  Depending on what you want to do you can even have it run in the background silently and parse the source code of the page rather than highlight/copy/paste.

Its not exactly easy, but not exactly hard.  If you get a starting point you can get help here on the forum.

Im still not very good with the word/excel udfs but Water is the expert and always helped when I needed it. 

Edited by ViciousXUSMC
Link to comment
Share on other sites

Thanks for the kind words :)
I will do my very best!

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Hey ViciousXUSMC and Water

Thanks for the reply, I don't think I'm able to get the data through its source code, it seems that it shows under java script or something.

I have attached the link and pic for your reference:

http://www.sgx.com/wps/portal/sgxweb/home/company_disclosure/stockfacts?page=1&code=ADQU

Previous Open Price0.65Previous Day High/Low0.655-0.645
Previous Day Volume0.15 mmPrevious Close0.645
Previous Close Date22/Sep/201552 Week High/Low0.925-0.595
5-Year Beta-Shares Outstanding1,099.12 mm
Average 3-month Volume1.78 mmNormalized Diluted EPS0.04
Total Market CapS$ 708.9 mmFloat65.48%
6-month VWAP info.jpgSGD 0.707 as of22/Sep/2015 

 

So my question is what function should I use for getting the Numbers copied?

Link to comment
Share on other sites

I just had a quick look at it. Wouldn't it be easier to use one of their data services to access what you need?

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...