ExcelFile.CopyCell Method
Copies one cell from one workbook to another. If the cell has a formula, it will be offset so it matches the new destination. Note: You will normally not need this method. To copy a range of cells from a workbook to another use InsertAndCopyRange(TXlsCellRange, Int32, Int32, Int32, TFlxInsertMode, TRangeCopyMode, ExcelFile, Int32) instead. To copy a full sheet from one file to another, use InsertAndCopySheets(Int32, Int32, Int32, ExcelFile).
Syntax
Namespace: FlexCel.Core
public abstract void CopyCell(ExcelFile sourceWorkbook, Int32 sourceSheet, Int32 destSheet, Int32 sourceRow, Int32 sourceCol, Int32 destRow, Int32 destCol, TRangeCopyMode copyMode)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| sourceWorkbook | ExcelFile | File from where we want to copy the cell. | |
| sourceSheet | Int32 | Sheet in sourceWorkbook where the data is. | |
| destSheet | Int32 | Sheet in this file where we want to copy the data. | |
| sourceRow | Int32 | Row on the source file of the cell (1 based) | |
| sourceCol | Int32 | Column on the source file of the cell (1 based) | |
| destRow | Int32 | Row on the destination file of the cell (1 based) | |
| destCol | Int32 | Column on the destination file of the cell (1 based) | |
| copyMode | TRangeCopyMode | How the cell will be copied. |