hicksi
Board Regular
- Joined
- Mar 5, 2012
- Messages
- 203
Now that I've been able to access Web sites, I want to collect the data from a table on that site into my Excel spreadsheet.
In particular, I am trying to collect the list of studio albums for various bands from Wikipedia.
For example, I need to:
In particular, I am trying to collect the list of studio albums for various bands from Wikipedia.
For example, I need to:
- Access the page Rolling Stones Discography The Rolling Stones discography - Wikipedia
- Find a <h2> that looks like "Studio Albums"
- Within the code between this <h2> and the next <h2>
- Find a Table
- Select the whole table
- Paste the table into the Excel spreadsheet
- Repeat for another known band's discography page.