Worksheet.CopyPaste(String, Area)

Description

Copies an area of cells from another Worksheet to cells in this worksheet.

C#

vb.net

Parameters

destCell

A string indicating the upper-left cell of the destination area.

sourceArea

An area from the source workbook from which to copy.

Returns

An Area object representing the set of cells populated with the copied values.

Remarks

The copied data will overwrite the contents of the cells in this worksheet. The method behaves as if you had passed in CopyPasteProperties object initialized with CopyPasteType.All.

Examples

C#