Copy Ranges of Excel

Introduction

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 for Python Excel Library

Aspose.Cells for Python via .NET provides some overload Range.copy methods to copy the range. And Range.copy_style only the copy style of the range; Range.copy_data only the copy value of the range

Copy 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 for Python via .NET supports pasting the range with specific type.

Only Copy Data Of The Range

Also you can copy the data with Range.copy_data method as the following codes:

Advance topics

Create Workbook and Worksheet Scoped Named Ranges Cut and Paste Range