Search

Copy Entire Data

Last Updated: Dec 28, 2022

Articles

Use this function to copy the values and metadata from the given input range and provides the ouput in an XML format.

Syntax

Copy Entire Data (source_sheet, source_range, destination_sheet, destination_cell, paste_type)

Parameters

Input Parameter Name Description
range Range of cells (first cell and last cell) separated by : to copy

Returns

Return value Description
XML Returns the copied data in XML format

Sample

Copy Entire Data (A1:B10)

  • Copies the values and metadata present in the range A1:B10.
    Returns the copied data in XML format.

To view all the Excel functions, click here.

Did you find what you were looking for?