Search

Copy MetaData

Last Updated: Dec 1, 2020

Articles

Use this function to copy the values and metadata from the input range and provide output in an XML format.

Syntax

Copy MetaData (range)

Parameters

Input Parameter Name Description
range Two cell values (first cell and last cell) separated by ‘:’ to copy the metadata

':' is used as separator between the cells.

Returns

Return value Description
XML Returns the copied data in a XML format

Sample

Copy MetaData (B2:E3)

  • Copies values and metadata from cell ‘B2’ up to cell ‘E3’ and returns the output in an XML format.

To view all the Excel functions, click here.

Did you find what you were looking for?