Results 1 to 4 of 4

Thread: Looking for Excel Web Query for Java Applet working sample

  1. #1
    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.

  2. #2
    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.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    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.

  4. #4
    Join Date
    Aug 2011
    Posts
    566

    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.

Similar Threads

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

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,650,824.25172 seconds with 17 queries