asked on

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

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

Ryan Chong

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

attached is the data imported from web.

is this consider imported "successfully" ?
28709900.xlsx

Jann Krynauw

ASKER

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 Krynauw

ASKER

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

Ryan Chong

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

Jann Krynauw

ASKER

I just would like to import the table not the page

Ryan Chong

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 Krynauw

ASKER

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.

Ryan Chong

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 Krynauw

ASKER

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

ASKER CERTIFIED SOLUTION

Jann Krynauw

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ryan Chong

>>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 Krynauw

ASKER

there was no solution, so I marked my own comment as the solution.