Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting HTML table into excel - Problem
Hello all, i have a HTML page (Print Preview) out of which i want to
copy a table, can this be done automatically ? If not, i can do it manually but i am left with a lot of hyperlinks that i need to get ride of and i loose all the dates that are on the preview, even if i format the column for "date". Any suggestions or help would be much appreciated... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting HTML table into excel - Problem
Hi Lee
Could you use a Web Query to do it?? Or have you tried this already?? If not it can be found under the Data Menu / Import External Data / New Web Query. From here navigate to your page and click the arrow beside the table you want and then Click Import. Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting HTML table into excel - Problem
Print preview from where, the browser?
If you have a copy in IE you could use the HTML Document Object Model to copy the table contents to Excel (by iterating through the rows & cells and copying their contents) Tim "Les Stout" wrote in message ... Hello all, i have a HTML page (Print Preview) out of which i want to copy a table, can this be done automatically ? If not, i can do it manually but i am left with a lot of hyperlinks that i need to get ride of and i loose all the dates that are on the preview, even if i format the column for "date". Any suggestions or help would be much appreciated... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Excel file for .html table | Excel Discussion (Misc queries) | |||
pasting html table into excel | Excel Discussion (Misc queries) | |||
pasting a html table into excel | Excel Discussion (Misc queries) | |||
.. any help appreciated .. i think it's a pasting HTML problem. | Excel Discussion (Misc queries) | |||
Pasting HTML table with feet/inches column, excel changes it to da | Excel Discussion (Misc queries) |