View Single Post
  #3   Report Post  
Dmitry Kopnichev
 
Posts: n/a
Default How to import a table on a Web page to Excel?

The table in the webpage looks as a table, but it is a text with columns in
the table delimited by several spaces, not by a htm table tag. Therefore,
the no. of the table cannot be found out from the source html page counting
<table tag, can be? The table is between other text.
"R.VENKATARAMAN" сообщил/сообщила в новостях следующее:
...
fist use < data-getexternal data (importdata) using a webquery into excel
then
data-texttocolumn using space as delimiter

you must know the no. of the table in the webpage which can be found out
from the source html page counting
<table tag or by trial and error
--
remove $$$ from email addresss to send email

=========================
"Dmitry Kopnichev" wrote in message
...
Hello
How to import a table on a Web page to Excel? Columns in the table are
delimited by several spaces, not by a htm table tag.