Import Data into Excel

[mastermind007]

Another tool in windows that may be able to get data out of your website is a tool named "Easy Web Extract".

It is a paid product ($60) but you need to be able to reconstruct using the tool and then use the HTML DOM to work out the data and extract it.

Again, this will also involve scripting

Of the earlier mentioned Linux utilities, lynx is the simplest but it completely strips the website and removes all of the HTML control tags ...

 

[amitrandive]

When you access the website from a regular internet browser, it works fine but when you access it from the Excel, the website seems to springing an invisible JSON object that is then preventing Excel from accessing the underlying table ...

If you access to UNIX (LINUX) operating system on your network that you can use, it has lots of utilities such as lynx, curl, wget that may be able to bypass all this nonsense and get to the data.

Outline of Steps
1) Develop the script on linux box and save the file on shared drive that is common between windows and linux. Your Script will have to written such that it can repeatedly fetch the data and keep overwriting the text file.

2) Excel will than have to repeatedly read from the text file.

3) Synchronization is also the key; Excel must not attempt to read the file while script is writing and script must not write while Excel is reading.

Ports of those linux utilities do also exist for Windows but they do involve a learning curve

Thanks MM!!

I am trying to get the data in by the steps outlined in

https://support.office.com/en-gb/ar...Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba

http://www.dummies.com/how-to/content/how-to-import-online-data-into-excel-2010-with-a-w.html

But the yellow box does not appear for importing.

 

[VJAY]

Same like amits problem to me too ...unable to import this data
anyone have solution then please guide....

 

[manishchan]

Thanks MM!!

I am trying to get the data in by the steps outlined in

https://support.office.com/en-gb/ar...Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba

http://www.dummies.com/how-to/content/how-to-import-online-data-into-excel-2010-with-a-w.html

But the yellow box does not appear for importing.

Same like amits problem to me too ...unable to import this data
anyone have solution then please guide....

Yeah.. web query is the easy way to fetch the data in excel. But there is one thing.. the website content has to be query enabled. Sometimes website's contents are blocked from web scraping and therefore you won't see those yellow arrow everywhere. Even on NSE site some data can be fetched with web query and some can'not (like VJAY gave an example above) So basically.. if you see the yellow arrow, then only the web query will work. Else either you have to find another site with similar data or use some other method (not sure abt other methods )

 

[mastermind007]

Thanks MM!!

I am trying to get the data in by the steps outlined in

https://support.office.com/en-gb/ar...Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba

http://www.dummies.com/how-to/content/how-to-import-online-data-into-excel-2010-with-a-w.html

But the yellow box does not appear for importing.

That is exactly what I mean. For yellow boxes to appear, Excel should be able to parse the data and extract tables. A script on the site is blocking that.