Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to import a table on a Web page to Excel?
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. |
#2
|
|||
|
|||
How to import a table on a Web page to Excel?
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
How to import a table on a Web page to Excel?
if this is the only table try checking <only tables the second item under
2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
#5
|
|||
|
|||
How to import a table on a Web page to Excel?
Clicking <Click to select this table in the dialog box <new web query
selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... if this is the only table try checking <only tables the second item under 2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
#6
|
|||
|
|||
How to import a table on a Web page to Excel?
in that case checking <only table in new webquery window should be ok for
you "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in the dialog box <new web query selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... if this is the only table try checking <only tables the second item under 2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
#7
|
|||
|
|||
How to import a table on a Web page to Excel?
Clicking <Click to select this table in new WebQuery window imports all
text, not only tables, without separating to columns. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... in that case checking <only table in new webquery window should be ok for you "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in the dialog box <new web query selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... if this is the only table try checking <only tables the second item under 2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
#8
|
|||
|
|||
How to import a table on a Web page to Excel?
find the delimiters they are using usually commas or some other signs.
hightlight the data in the first column only then use data-text to columns and follow the wizard. From your earlier message it looks the delimiter are spaces then in the step 2 uncheck all the delimiters and check only <space. then you will see in the table below that the vertical lines are inserted at proper places and then you can finish it. hope you succeed. -- remove $$$ from email addresss to send email ============================== "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in new WebQuery window imports all text, not only tables, without separating to columns. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... in that case checking <only table in new webquery window should be ok for you "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in the dialog box <new web query selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... if this is the only table try checking <only tables the second item under 2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
#9
|
|||
|
|||
How to import a table on a Web page to Excel?
How to import tables only, not all text? Clicking <Click to select this
table in new WebQuery window imports all text, not only tables. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... find the delimiters they are using usually commas or some other signs. hightlight the data in the first column only then use data-text to columns and follow the wizard. From your earlier message it looks the delimiter are spaces then in the step 2 uncheck all the delimiters and check only <space. then you will see in the table below that the vertical lines are inserted at proper places and then you can finish it. hope you succeed. -- remove $$$ from email addresss to send email ============================== "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in new WebQuery window imports all text, not only tables, without separating to columns. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... in that case checking <only table in new webquery window should be ok for you "Dmitry Kopnichev" wrote in message ... Clicking <Click to select this table in the dialog box <new web query selects all text on the page, not just the table. There are other tables (with columns delimited by spaces)separated by text on this page. I need the other tables too. "R.VENKATARAMAN" сообщил/сообщила в новостях следующее: ... if this is the only table try checking <only tables the second item under 2 of the dialog box <new web query "Dmitry Kopnichev" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
Open excel from htm page | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel | |||
Can I import a Word table to an Excel spreadsheet? | Excel Worksheet Functions |