+ Reply to Thread
Results 1 to 2 of 2

google sheet importxml formulla not getting data

  1. 10-13-2022, 02:50 AM #1
    Ajay45822
    Ajay45822 is offline
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Agra
    MS-Off Ver
    Office 2010
    Posts
    241

    google sheet importxml formulla not getting data

    We want to get data from below url

    https://www.amazon.in/Indian-Economy...55321139&psc=1

    we are using the below formula =importxml(B1, "//span[@class='a-size-medium a-color-price']"))
    where B1 is the url which we have given on top

    when we have change the span class for getting second value, we are getting #N/A =importxml(B1, "//span[@class="a-size-small a-color-secondary mbc-delivery']")

    Note : We want only table/data which heading are "Other Sellers on Amazon", its comes on right side after add to cart and buy new

    we just want Price, Delivery charges and sold by

    Thanks in advance
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 10-16-2022, 12:34 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: google sheet importxml formulla not getting data

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Google SHeets: Count Checked checkboxes in filtered data of google sheet
    By Faizan Naseem in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 07-07-2022, 05:42 AM
  2. IMPORTXML query returning redundant data in several cells
    By ISAO in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 14
    Last Post: 08-17-2021, 03:08 PM
  3. IMPORTXML query returning redundant data in several cells
    By ISAO in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2021, 07:00 PM
  4. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  5. [Google Sheets ] Using ImportXML returns a wrong value
    By Kimberley in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 11-07-2017, 02:10 PM
  6. =if(and formulla for two individual data
    By SANKARTUDU in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2014, 12:49 PM
  7. If(and formulla for two individual data
    By SANKARTUDU in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 09-15-2014, 02:57 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