R
RD Bean
I have had some success reading a web page directly with
Microsoft Query, which is an add-in to Excel. After you
have added it, click on Data, then Import External Data,
then "New Web Query". You can paste the URL in where
needed. When the web page opens, yy home version shows
little arrows that identify the 'tables' on the page
available for import. Just click on the arrow and the data
appears in Excel, with headings for each column.
My version at work is not as clean - I have to either read
the HTML source code and guess what the table number is,
or just guess and type in numbers until I get the one I
want. For instance on the NASCAR race results page, there
are about 4 or 5 headers that count as tables, and the
results are later in the page.
I did not find much documentation on this, I just did it
by trial and error.
Microsoft Query, which is an add-in to Excel. After you
have added it, click on Data, then Import External Data,
then "New Web Query". You can paste the URL in where
needed. When the web page opens, yy home version shows
little arrows that identify the 'tables' on the page
available for import. Just click on the arrow and the data
appears in Excel, with headings for each column.
My version at work is not as clean - I have to either read
the HTML source code and guess what the table number is,
or just guess and type in numbers until I get the one I
want. For instance on the NASCAR race results page, there
are about 4 or 5 headers that count as tables, and the
results are later in the page.
I did not find much documentation on this, I just did it
by trial and error.