6 ms·
Can I parse response (JSON, XML, whatever) into cells without VBA?
by ComodoHacker 2y ago
Can I parse response (JSON, XML, whatever) into cells without VBA?
- xnx 2y agoWith some effort, probably: =FILTERXML() https://support.microsoft.com/en-us/office/filterxml-function-4df72efc-11ec-4951-86f5-c1374812f5b7 https://support.microsoft.com/en-us/office/filterxml-functio... Could also do some crude/fragile parsing with aforementioned regex functions.
- deleted 2y ago[deleted]