Comment by xnx | Hacker News Reader

Top New Best Ask Show Jobs

Comment by xnx | Hacker News Reader

Parent Full thread

Can you do this with the =WEBSERVICE() function? https://support.microsoft.com/en-us/office/webservice-functi...

Can I parse response (JSON, XML, whatever) into cells without VBA?

With some effort, probably: =FILTERXML() https://support.microsoft.com/en-us/office/filterxml-functio...

Could also do some crude/fragile parsing with aforementioned regex functions.

Reply on news.ycombinator.com