XlsFile.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 ExcelFile.InsertAndCopyRange(TXlsCellRange, Int32, Int32, Int32, TFlxInsertMode, TRangeCopyMode, ExcelFile, Int32) instead. To copy a full sheet from one file to another, use ExcelFile.InsertAndCopySheets(Int32, Int32, Int32, ExcelFile).
Syntax
Namespace: FlexCel.XlsAdapter
public override 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. |