Ask Experts Questions for FREE Help !
Ask
    vikasgupta7's Avatar
    vikasgupta7 Posts: 1, Reputation: 1
    New Member
     
    #1

    Aug 20, 2010, 10:37 PM
    How to get data from jsp web page to excel
    Hi,

    I want to download daily Stock market data from website "http://etintelligence.com/etig/researchchannels/markets/bsestockquotes.jsp" into excel. My problem is that I will have to click each alphabet on this page to get data for all stock starting with that alphabet. Which means I will have to click each of the alphabets (28 clicks) and copy paste data manually to excel.

    Now is there a possibility to download all the data in one go ( one click) using some software. Excel imports data for only the face page, since the page is java enabled and uses getdata utility to bring in data for other alphabets.

    Can anyone help me please??


    Regards Vikas
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Aug 21, 2010, 08:54 PM

    I've moved this to a more appropriate place. Despite that it's related to stock, the question is about the website and Excel, not about a finance issue.
    Jakes12345's Avatar
    Jakes12345 Posts: 1, Reputation: 1
    New Member
     
    #3

    Mar 16, 2011, 12:38 AM
    Importing data to your excel sheet is not a big issue while you are using some software to import it like market data excel, which can let your all market data from your JSP page to your desired excel sheet within a one go. I have been using this software since a long time and find great reliable when I want to transfer data form my java page to excel sheet.You can try this.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Maximize a web page every time I open. I use Yahoo as my primary web page. [ 1 Answers ]

When I now open Yahoo as my primary IE web page it is always minimized. Have tried a 3 suggestions on this site but to no avail. Thanks in advance! floater74

Display data in next jsp page [ 1 Answers ]

I want to display a set of data in a jsp page . On one jsp page , I select one date This date is present in a form, and it is passed onto a servlet file from where, a database query is accessed This query compares the date entered by user, and that date present in a database table Then, selects...

How to retrive data from database in phased manner using jsp [ 1 Answers ]

I want to show data(that are retrived from database) in phased maner in the web browser.I want to say that I have supoose 12 records present in database.first only 4 records are to be shown,then when pressing a "next" button next 4 records to be shown in web browser and so on.


View more questions Search