Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 4 of 4

Thread: how to submit Javascript form with excel macro to fetch data by web query in excel

  1. #1
    Junior Member
    Join Date
    Aug 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default how to submit Javascript form with excel macro to fetch data by web query in excel

    Dear Friends

    Please excuse me if this is not the correct section for this thread.

    I'm trying to import html based table in excel using web query. data gets fetched for the default selected items in the dropdown box but not for rest of the items in the dropdown list. I guess, a javascript seems to be the catch.

    I've to select other items form the dropdown box and click on 'Go' to get the table in web browser but have no clue how to get it done automated for excel web query.

    here is the link to the page.

    on googling I figured out that there could be a way if one can code a macro to submit the javascript form but I didn't understand how to do it.
    I'm not so familiar with html and javascript, please help me out.
    Thanks


  2. #2
    Grand Poobah
    Join Date
    Mar 2011
    Posts
    1,514
    My Mood
    Grumpy
    Thanks
    0
    Thanked 165 Times in 156 Posts

    Default Re: how to submit Javascript form with excel macro to fetch data by web query in exce

    Take a look at the top of the page. See where it says JAVA not Javascript.
    Improving the world one idiot at a time!

  3. #3
    mmm.. coffee JavaPF's Avatar
    Join Date
    May 2008
    Location
    United Kingdom
    Posts
    3,336
    My Mood
    Mellow
    Thanks
    258
    Thanked 287 Times in 225 Posts
    Blog Entries
    4

    Default Re: how to submit Javascript form with excel macro to fetch data by web query in exce

    Thread moved to Other Programming Languages

    I suggest you search for a dedicated JavaScript forum.
    Please use [highlight=Java] code [/highlight] tags when posting your code.
    Forum Tip: Add to peoples reputation by clicking the button on their useful posts.

    Looking for a Java job? Visit - Java Programming Careers

  4. #4
    Junior Member
    Join Date
    Aug 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: how to submit Javascript form with excel macro to fetch data by web query in exce

    Alright.
    Thanks Guys

Similar Threads

  1. Importing excel data
    By supriya ramjee in forum File I/O & Other I/O Streams
    Replies: 11
    Last Post: October 20th, 2012, 09:39 AM
  2. how to read chinese data from excel to java
    By swapna in forum File I/O & Other I/O Streams
    Replies: 5
    Last Post: November 17th, 2011, 06:02 AM
  3. Exporting Data to Excel Spreadsheet
    By PineAppleKing in forum Java Theory & Questions
    Replies: 5
    Last Post: May 19th, 2011, 03:03 PM
  4. fetch HTML page content from the web ( by executing javascript ) using stand alone
    By johnyabu@gmail.com in forum Java Theory & Questions
    Replies: 7
    Last Post: February 8th, 2011, 06:25 AM
  5. How to fetch integer data from excel
    By nehakuls in forum JDBC & Databases
    Replies: 5
    Last Post: May 14th, 2010, 01:44 AM

Tags for this Thread