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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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 ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 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.
Jann KrynauwPartnerAuthor Commented:
Here is an example of the same table on a page without any scripts http://pf.rezco.net/test/
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ok result as attached if query to http://pf.rezco.net/test/
28709900-b.xlsx
Jann KrynauwPartnerAuthor Commented:
I just would like to import the table not the page
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 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.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
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 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
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?

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 ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>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 KrynauwPartnerAuthor Commented:
there was no solution, so I marked my own comment as the solution.
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.