+ Reply to Thread
Results 1 to 7 of 7

Excel Query data from web

  1. 08-01-2023, 04:25 PM #1
    rachelwahid
    rachelwahid is offline
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Excel Query data from web

    Dear Concern,
    I am trying to get data from mention webpage to my excell sheet. That page data table contains around 10000 row but show only around 100 row & other row need to see by clicking next, next. By data query from web in my excell come only first 100 row but i need full data up to 98 in the chart.

    Please help me in this regards & if possible also suggest me a sample worksheet with this.

    Page Link: https://www.investing.com/crypto/currencies
    https://www.investing.com/crypto/currenciesSample page .jpg
    I also attached screenshot of the chart in the page which i need full data.

    Best regards
    Wahid
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 08-02-2023, 03:35 AM #2
    rachelwahid
    rachelwahid is offline
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: Excel Query data from web

    Hi,
    Please help me anyone.

    Wahid
    Reply With QuoteRegister To Reply
  3. 08-02-2023, 03:43 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,939

    Re: Excel Query data from web

    PowerQuery: https://www.microsoft.com/en-gb/down....aspx?id=39379

    Tutorial: https://www.myonlinetraininghub.com/...web-by-example

    followed by: https://www.myonlinetraininghub.com/...es-power-query
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 08-02-2023, 07:12 AM #4
    rachelwahid
    rachelwahid is offline
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: Excel Query data from web

    Hi Concern,
    Thanks for your nice support but already I have query option in my excel. And there load only 100 row from that page but I need all rows on 5hat table up to 98 page that I share via image & marked.

    Please help me
    Reply With QuoteRegister To Reply
  5. 08-02-2023, 07:15 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,939

    Re: Excel Query data from web

    That's why you need to follow the THIRD link which shows you how to add extra pages.

    Why are you calling me 'Concern'???
    Reply With QuoteRegister To Reply
  6. 08-02-2023, 07:58 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,939

    Re: Excel Query data from web

    Seen, but no response ...

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Reply With QuoteRegister To Reply
  7. 08-03-2023, 09:47 AM #7
    rachelwahid
    rachelwahid is offline
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2019/ 64 bit
    Posts
    159

    Re: Excel Query data from web

    Sorry for late reply.

    Actually I tried many times but Cant build . Please help me with solved file.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  2. SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 09:52 AM
  3. [SOLVED] SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-19-2016, 09:31 AM
  4. Vlookup query : How to pull data from raw excel files into a master excel file?
    By jamesjamesiata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2013, 06:26 AM
  5. Running an access query from an excel sheet and having an excel sync with the query
    By excelaspire0219 in forum Excel General
    Replies: 0
    Last Post: 02-10-2009, 02:41 PM
  6. [SOLVED] Numbers/Text data missing from excel to excel query?
    By RAMAERTE in forum Excel General
    Replies: 0
    Last Post: 05-08-2006, 12:10 PM
  7. [SOLVED] Data too large for Excel, need to query Access data for results
    By Susan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-09-2006, 11:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1