excelxpathgoogle-sheetsgoogle-shopping
How Extract data from html with xpath
I'm trying to extract product prices from Google Shopping with Google Spreadsheet:
=IMPORTXML("https://www.google.com.br/?source=pshome-c-0-3&sa=X&ved=0ahUKEwjfguD5xaHKAhXMiZAKHWjuBi8Q7j8IEA#tbm=shop&q=Samsung+Galaxy+S6&spd=0";"/div[@class='product-results']/div[@class='psli'][2]/div[@class='pslicont']/div[@class='pslmain']/div[@class='pslline'][1]/div[@class='_tyb shop__secondary']/span[@class='price']/b")
My xpath query is:
/div[@class='product-results']/div[@class='psli'][2]/div[@class='pslicont']/div[@class='pslmain']/div[@class='pslline'][1]/div[@class='_tyb shop__secondary']/span[@class='price']/b
But i don't have results.
What's Wrong?
HTML from Google Shopping
Solution
Because google in not returning HTML in actual. See the source code of the page
view-source:https://www.google.com.br/?source=pshome-c-0-3&sa=X&ved=0ahUKEwjfguD5xaHKAhXMiZAKHWjuBi8Q7j8IEA#tbm=shop&q=Samsung+Galaxy+S6&spd=0
- List only workdays in given dynamic month
- How to read SharePoint Online (Office365) Excel files into Python specifically pandas with Work or School Account?
- Difference between .Delete and .Clear in Excel VBA?
- Merging cells in Excel using Apache POI
- Having issues not including duplicate words randomly populating 3 columns in Excel
- Excel: Filter a sheet from value in another sheet
- Merge two cells keeping/adding formatting
- Output all cell colors from a range in Excel using Office Scripts
- Using EPPlus with a MemoryStream
- Creating an office script where it looks at the first column in each sheet and inserts a column based on the value in the first column
- Putting a concatenate inside of a count if
- GetMyFeesEstimate API Amazon vba
- "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns" Error
- Excel fill numbers within a range
- VBA isString vs isNumeric
- How to use a cell range to color another one?
- Macro Help: Workbook to New Doc Copying Only the Cell Values
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel VBA Autofilter Values Not Equal To Asterisk (*)
- How do I check If autosave is on and then switch it back on if it is not?
- Driving Excel from Python in Windows
- VBA Excel Cannot open external workbook
- TypeError while using Openpyxl to read file
- Excel VBA to hide rows if more than 10 blanks
- I have a list of lat/long points of interest, and lat/longs for public trans how to find addresses with have all three public trans?
- Excel: how to search by two rows and one column
- Excel to Word VBA The formatting does not apply to the correct text
- Select some adjacent and non-adjacent column ranges and save to pdf as if they were all adjacent
- How do I convert a single vertical row into multiple row array in Excel?
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit