importxml

I currently use ImportXML to import some stat tables. Season 2022-23 =IMPORTXML("Team Season Totals - Natural Stat Trick","//tr") and Pre-Season 2022-23 =IMPORTXML("Team Season Totals - Natural Stat Trick","//tr") However I want to update it to this years pre-season, but when i replace the...

Hi, is it possible to import in Google Sheets the inventory number from this query string? https://www.bibliotechediroma.it/opac/query/%s?bib=RMBO2&context=tmatmo (RMBO2 is the identification code of “Biblioteca Morante”). The inventory number is in “Lo trovi in” > Biblioteca Elsa Morante >...

The IMPORTXML formula for Google Sheets is "=IMPORTXML(Url, xpath_query)". For example webpage Amazing Spider-Man #365 Value - GoCollect, I've been trying to extract the data under "Preview Grades", specifically the FMV data per grade. I don't know what I'm doing wrong, but I can't figure out...

Hi all, I am attempting to create a portfolio for my financial stocks using Google spreadsheet. I would like to create something like this: [https://ibb.co/SBDJhgs](https://ibb.co/SBDJhgs) In this case A2 is where I put the ticker, for example, AAPL stands for Apple. Afterwards, I hope to...

Does anyone know how to add a record to an xml file using an xslt file? This record should just be a copy of the previous row but with all its entries blank so that when I use ImportXML in VBA I get a sheet with data + one blank row at the bottom

Hey! Google sheets has a function called ImportXML, basically you give a URL and an Xpath and it automatically return that part of the website. It is a great feature however you can only use it for a few cells. My question is that is there a way to achieve this in excel 2016? I know about...

I have a spreadsheet that I'm using to import data from a webpage. I've been able to pull in everything from the page but I'm looking for the information in a specific node. I'm having trouble pulling it in. Here's the info Site: https://leagueofcomicgeeks.com/profile/mauricem72/pull-list I'm...

Looking for the appropriate syntax to switch the "ProhibitDTD" setting to False in order to allow the following VBA application to run in an excel module. Its an issues consistent with MSXML 6.0. Application.importXML _ DataSource:="C:\Users\xxxxxxx\Desktop\12_3_2014_11_35_57_AM - Copy.xml"...

I need to be able to submit an XML request to a WSDL, get the XML response and deal with it. The manual way is that I go into SOAP-UI, load up a request, supply parameters, click the green triangle, get the response, and save it as an XML file. Then in Excel I import it using Data / From Other...