Results 1 to 2 of 2

google sheet importxml formulla not getting data

Threaded View

Ajay45822 google sheet importxml... 10-13-2022, 02:50 AM
FDibbins Re: google sheet importxml... 10-16-2022, 12:34 AM
  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1