Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim dataOnly As Boolean
instance.CopyRange(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount, dataOnly) |
Parameters
- fromRow
- Row index of top-left cell in block to copy
- fromColumn
- Column index of top-left cell in block to copy
- toRow
- Row index of top-left cell in destination
- toColumn
- Column index of top-left cell in destination
- rowCount
- Number of rows in the block
- columnCount
- Number of columns in the block
- dataOnly
- Whether only the data is copied, or the data and formatting
Exceptions
Example
This example uses the CopyRange method.
C# | Copy Code |
---|
fpSpread1.Sheets[0].Cells[0, 0].Text = "test";
fpSpread1.Sheets[0].Cells[0, 1].Text = "B";
fpSpread1.Sheets[0].Cells[0, 2].Text = "C";
fpSpread1.Sheets[0].Cells[0, 2].BackColor = Color.Crimson;
private void button1_Click(object sender, EventArgs e)
{
fpSpread1.Sheets[0].CopyRange(0, 0, 5, 0, 3, 3, false);
} |
VB.NET | Copy Code |
---|
FpSpread1.Sheets(0).Cells(0, 0).Text = "test"
FpSpread1.Sheets(0).Cells(0, 1).Text = "B"
FpSpread1.Sheets(0).Cells(0, 2).Text = "C"
FpSpread1.Sheets(0).Cells(0, 2).BackColor = Color.Crimson
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
FpSpread1.Sheets(0).CopyRange(0, 0, 5, 0, 3, 3, False)
End Sub |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also