We help IT Professionals succeed at work.

Html Table into Excel - html table not displaying as an option

Jann Krynauw
Jann Krynauw asked
on
83 Views
Last Modified: 2015-09-26
Hi,

Any particular reason why the table on this page: http://institutional.rezco.net/our-funds/ is not available to download?

I've attached a screenshot of Excel - > Data -> Get External Data -> From Web

Regards
Jann
Capture.PNG
Comment
Watch Question

CERTIFIED EXPERT

Commented:
there's a javascript error which probably prevent your webpage to be downloaded "completely".

JavaScript error
attached is the data imported from web.

is this consider imported "successfully" ?
28709900.xlsx
Jann KrynauwPartner

Author

Commented:
Thank you, I was also able to import the details as per your attachment and is not ideal

I'm the developer of the website as well with LiveChat as an addin.
Jann KrynauwPartner

Author

Commented:
Here is an example of the same table on a page without any scripts http://pf.rezco.net/test/
CERTIFIED EXPERT

Commented:
ok result as attached if query to http://pf.rezco.net/test/
28709900-b.xlsx
Jann KrynauwPartner

Author

Commented:
I just would like to import the table not the page
CERTIFIED EXPERT

Commented:
apparently that page contains other info, so you need to write a macro to clean the sheet that was imported so that eventually you can get the table you wanted.
Jann KrynauwPartner

Author

Commented:
any ideal formatting one could apply to a page? html tags? that will make the standard excel import function work properly?
 
MS Office refers to <pre> or <table> tags only

I do not want to use any macros.
CERTIFIED EXPERT

Commented:
by using Get External Data wizard as what we have tried, it seems that these are the results we get >> what we see is what we get.

it seems that no shortcuts for us to get the desired table, UNLESS we need to do some processing on the page we have imported/download, which may require some programming/ macro.

>>any ideal formatting one could apply to a page? html tags? that will make the standard excel import function work properly?
probably you can create another page in the web portal so that it ONLY contains the HTML of the expected table, and then we can try the Get External Data wizard to see if we can get the expected result....
Jann KrynauwPartner

Author

Commented:
seems like since most modern websites are no longer table based design, this 'Get External Data' feature do not work well with never websites.

I've attached two files.
old-web-with-links.png
new-web-with-no-links.PNG
Partner
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
>>so in short, it is not possible to have a 'clean & simple' setup - one has to use macros or third party software to pull data from newer websites.

I think we may need to do some text mining in order to get what you need, but it would need to compare with the HTML codes (tags) that have been downloaded from web to your local.
Jann KrynauwPartner

Author

Commented:
there was no solution, so I marked my own comment as the solution.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.