- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
- Worksheet
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Logging
- Defined Names
- Templates
- File Operations
- Release Notes
Cut or Copy Across Sheets
In GcExcel .NET, it is possible to cut or copy data across a range of cells or several worksheets without the need to copy and paste the information into each of the cells or sheets individually.
For instance, let's say you want the same title text to be put into different worksheets within a workbook. To accomplish this, if you type the text in one worksheet and copy,paste it into every other worksheet, the process can turn out to be both cumbersome and time-consuming.
A quick way of doing this would be to cut or copy information across cells or sheets using:
The Copy method to copy rows, columns, or a range of cells and paste them to destination.
The Cut method to cut rows, columns, or a range of cells and paste them to destination.
Copy across sheets
Refer to the following example code to perform copy operation in a workbook.
// Copy across sheets
worksheet.Range["A5"].Copy(worksheet2.Range["A1"]);Cut across sheets
Refer to the following example code to perform cut operation in a workbook.
// Cut across sheets
worksheet.Range["A2"].Cut(worksheet2.Range["A3"]);