Last Updated: Dec 28, 2022
Use this function to copy the values and metadata from the given input range and provides the ouput in an XML format.
Copy Entire Data (source_sheet, source_range, destination_sheet, destination_cell, paste_type)
Input Parameter Name | Description |
---|---|
range | Range of cells (first cell and last cell) separated by : to copy |
Return value | Description |
---|---|
XML | Returns the copied data in XML format |
Copy Entire Data (A1:B10)
To view all the Excel functions, click here.