Dump

  =Dump({object vector}, [transpose=FALSE]) : object

Results from function inside Excel


Purpose

Macro function that takes an array output of another function and Dumps it on the spreadsheet.

Using this function together with an array function such as XPathOnUrl is pretty powerful (and will make it work like Google Docs’s ImportXML).

Note: Dump() adds a comment in the formula cell to be able to remember what cells to clean-up when input changes in size.

Converting to values

We recommend using the Converter tool to convert dump formulas to values. The Converter also removes the comments automatically.


See

Guides

Related Functions


Get help with this function in the community →