GrapeCity.Spreadsheet.IRange.Copy

Copy Method

Copies the data from a range of cells to a specified range of cells.

bool Copy(int toRow, int toColumn, ManipulationOptions options = ManipulationOptions.All)

Function Copy(toRow As Integer, toColumn As Integer, Optional options As ManipulationOptions = ManipulationOptions.All) As Boolean

Type	Name	Description
int	toRow	Row index of start of range to which to copy
int	toColumn	Column index of start of range to which to copy
ManipulationOptions	options	The options indicates which data type will be performed.

Type	Description
bool	`true` if the cell range is copied successful, `false` otherwise.

Copies the data from a range of cells to a specified range of cells.

bool Copy(IRange destination, ManipulationOptions options = ManipulationOptions.All)

Function Copy(destination As IRange, Optional options As ManipulationOptions = ManipulationOptions.All) As Boolean

Type	Name	Description
IRange	destination	The specified range will be copied.
ManipulationOptions	options	The options indicates which data type will be performed.

Type	Description
bool	`true` if the cell range is copied successful, `false` otherwise.

Copies the data from a range of cells to a specified range of cells.

bool Copy(string destination, ManipulationOptions options = ManipulationOptions.All)

Function Copy(destination As String, Optional options As ManipulationOptions = ManipulationOptions.All) As Boolean

Type	Name	Description
string	destination	The specified range will be copied.
ManipulationOptions	options	The options indicates which data type will be performed.

Type	Description
bool	`true` if the cell range is copied successful, `false` otherwise.

Copies the data from a range of cells to clipboard.

bool Copy(bool showUI = false, bool excludeHidden = false)

Function Copy(Optional showUI As Boolean = False, Optional excludeHidden As Boolean = False) As Boolean

Type	Name	Description
bool	showUI	`true` if the UI shows copying range; otherwise, only data is copied to clipboard.
bool	excludeHidden	`true` if copying excludes hidden range(s); `false` otherwise

Type	Description
bool	`true` if the cell range is copied successful, `false` otherwise.