Copy Ranges of Excel
In Excel, you can select a range, copy the range, then paste it with specific options to the same worksheet, other worksheets or other files.
Copy Ranges Using Aspose.Cells
Aspose.Cells provides some overload Range.Copy methods to copy the range.
Creating two ranges: the source range, the target range, then copying source range to target range with Range.Copy method.
See the following code:
Paste Range With Options
Aspose.Cells supports pasting the range with specific type.
Only Copy Data Of The Range.
Also you can copy the data with Range.CopyData method as the following codes: