gfpax.blogg.se

Excel import xml function
Excel import xml function






=Index(IMPORTXML('Price Links Sale'!A13, have no clue what I am doing, I'm just giving it the ole' college try. I tried this as well as a few other things with no success.

excel import xml function

=Index(IMPORTXML('Price Links Sale'!A13, I realized is that span in this case doesn't have a class. I wanted to add another column on my google sheet that checks the quantity in stock. This pulls the price for a non-foil near mint card. Where 'Price Links Sale' is the sheet that contains all of the URL's for each card I'm looking up. =Index(IMPORTXML('Price Links Sale'!A13, price-withoutTax']"),1) This is the working function I am using in the google sheet. I found a Google Sheet online that looks for the price of a MTG trading card from a specific web page. I usually spend 10x more time using google to try to automate something than it would have taken me to do it manually.

excel import xml function

I'd like to preface with I am a complete newbie to coding of all kinds.








Excel import xml function