If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
web query data... missing something
first part of the question:
it seems to me that the web query works very well for one particular piece of info, but doesn't work well as a regular function that can be copied, however i can't imagine it actually being that way. for instance, if cell A1=1 and cell B1=1, cell C1=A1+B1=2. if i drag/copy cell C1 down to cell C2, it will add cells A2 and B2. is there a way to do this with web queries? here is the specific application... i want to geocode a series of addresses using the yahoo maps api. i have a spreadsheet with all the normal address data (address, city, state) which is enough to geocode. i can only get one cell to pull a web query at a time. how can i replicate this down the column? second part to the question: the data from my query is returned as an xml file. all i want is the xml data plugged into that cell so i can manipulate it for proper formatting. what excel does instead is split it up into columns and rows instead, obviously trying to make things easier for me but in fact making it harder. how do i keep it from breaking up the data? third part to the question: same thing, only this time with html instead of xml. i can't seem to get the web query to get the raw html. how do i get the raw html instead of the "processed" html as it would appear on a web page? |
Thread Tools | |
Display Modes | |
|
|