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
Jann KrynauwPartnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
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
0
Jann KrynauwPartnerAuthor 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.
0
Jann KrynauwPartnerAuthor Commented:
Here is an example of the same table on a page without any scripts http://pf.rezco.net/test/
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ryan ChongCommented:
ok result as attached if query to http://pf.rezco.net/test/
28709900-b.xlsx
0
Jann KrynauwPartnerAuthor Commented:
I just would like to import the table not the page
0
Ryan ChongCommented:
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.
0
Jann KrynauwPartnerAuthor 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.
0
Ryan ChongCommented:
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....
0
Jann KrynauwPartnerAuthor 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
0
Jann KrynauwPartnerAuthor 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.

Therefore no solution to my original question?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongCommented:
>>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.
0
Jann KrynauwPartnerAuthor Commented:
there was no solution, so I marked my own comment as the solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.