Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Looking for Excel Web Query for Java Applet working sample

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-01-2012
Member
 
Join Date: Aug 2010
Posts: 15
Looking for Excel Web Query for Java Applet working sample

I cant seem to download data from a web site that displays data using Java Applets. For exmaple, try using web query on my site and it will return blank. Anyone has any idea how to deal with this.

Reply With Quote
  #2  
Old 27-01-2012
Member
 
Join Date: Jul 2010
Posts: 56
Re: Looking for Excel Web Query for Java Applet working sample

When a webpage is written in Javascript, web query will not be able to extract the data even though one can see the data in the Excel Browser. This is because these scripts are not in the html. To extract data, one would need to use other software like imacros scripting edition that will work with Excel's VBA.
Reply With Quote
  #3  
Old 16-01-2014
Member
 
Join Date: Nov 2010
Posts: 502
Re: Looking for Excel Web Query for Java Applet working sample

Web Query feature comes integrated in Excel. You can use it to capture live website data. For that you have to first understand who web query works. Without understanding the same it will be complicated for you to get proper information. There are some nice video tutorial on the web which has a comprehensive information on this process. You can follow the same. All you have to do is click on DATA > From WEB. Add a site URL and done. You can then choose the table that you want to keep in your sheet and get constant updates.
Reply With Quote
  #4  
Old 17-01-2014
Member
 
Join Date: Aug 2011
Posts: 564
Re: Looking for Excel Web Query for Java Applet working sample

If you are using a old office version then this feature will not work properly. You have to upgrade to the most latest one. The new version is capable of giving you more proper output. It is fast and easily capture data from the site. You can simply pull out everything and there is no issue with the output. If you get any error associated with live data then you have to skip that site. I had tried to pull live score in Excel, but it failed to work properly. I got some constant warning on the screen and then the office application crashed.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Looking for Excel Web Query for Java Applet working sample"
Thread Thread Starter Forum Replies Last Post
Parameters are not working in embedded SQL Query in Excel Ambition MS Office Support 2 21-02-2012 07:06 PM
How to run java applet program using cmd Rao's Software Development 3 07-01-2012 03:35 PM
Zoom in on a Java Applet? Bharata Software Development 6 21-10-2010 07:01 AM
Sample of Visual Basic macros for working with arrays in Excel Silent~Kid Windows Software 5 12-03-2010 03:43 AM
Link List Example in Java Sample program in Java trickson Software Development 2 04-08-2009 08:23 PM


All times are GMT +5.5. The time now is 04:23 AM.