Table of Contents

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.

See also