- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
-
Worksheet
- Work with Worksheets
-
Range Operations
- Access a Range
- Get Intersection, Union and Offset Range
- Access Areas in a Range
- Get Special Cell Ranges
- Access Cells, Rows and Columns in a Range
- Get Address of Cell Range
-
Cut or Copy Cell Ranges
- Cut or Copy Shape, Slicer, Chart and Picture
- Paste or Ignore Data in Hidden Range
- Find and Replace Data
- Get Row and Column Count
- Hide Rows and Columns
- Insert And Delete Cell Ranges
- Insert and Delete Rows and Columns
- Merge Cells
- Set Values to a Range
- Set Custom Objects to a Range
- Set Row Height and Column Width
- Auto Fit Row Height and Column Width
- Work with Used Range
- Measure Digital Width
- Set Default Values for Cell Range
- Ignore ErrorsIn Cell Range
- Set Cell Background Image for Cell Range
- Freeze Panes in a Worksheet
- Freeze Trailing Panes in a Worksheet
- Customize Worksheets
- Worksheet Views
- Cell Types
- Quote Prefix
- Tags
- Rich Text
- 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
-
Worksheet
- Templates
- File Operations
- Release Notes
Cut or Copy Cell Ranges
GcExcel .NET provides users with the ability to cut or copy a cell or a range of cells from a specific area and paste it into another area within the same worksheet. You can also choose whether to copy and paste the data in a hidden range in a worksheet. To know more, refer to Paste or Skip Data in Invisible Range.
In order to cut or copy data across multiple sheets, refer to Cut or Copy Across Sheets.
Copy Cell Range
GcExcel allows you to copy a cell or a range of cells in the worksheets by calling Copy method of IRange. To copy a single cell or a range of cells, specify the cell range to be copied, for example B3:D12.
GcExcel provides the following different ways to use the Copy method.
Example | Description |
|---|---|
Copy(sheet.Range["E5"]) | This method copies data from cell range B3:D12 and pastes the data to cell E5 onwards. |
Copy(sheet.Range["E5:G14"]) | This method copies data from cell range B3:D12 and pastes the data in cell range E5:G14. In case the range of cells copied does not fit into the destination cell range, the data is lost. |
Refer to the following example code in order to copy the cell range in a workbook.
// Copy the data of the range of cells
worksheet.Range["B3:D12"].Copy(worksheet.Range["E5"]);
//Or
worksheet.Range["B3:D12"].Copy(worksheet.Range["E5:G14"]);Cut Cell Range
GcExcel allows you to cut a cell or a range of cells in the worksheet by calling the Cut method of the IRange interface. To cut a cell or the range of cells, specify the cell range to be moved, for example B3:D12.
GcExcel provide the following different ways to use Cut method.
Example | Description |
|---|---|
Cut(sheet.Range["E5"]) | This method cuts the data from cell range B3:D12 and pastes the data to cell E5 onwards. |
Cut(sheet.Range["E5:G14"]) | This method cuts the data from cell range B3:D12 and pastes the data in cell range E5:G14. In case the range of cells cut does not fit into the destination cell range, the data is lost. |
Refer to the following example code to cut a range of cells in the workbook.
// Cut the data of the range of cell
worksheet.Range["B3:D12"].Cut(worksheet.Range["E5"]);
// Or
worksheet.Range["B3:D12"].Cut(worksheet.Range["E5:G14"]);