Table of Contents

TExcelFile.PasteFromXlsClipboardFormat Method

Overloads

TExcelFile.PasteFromXlsClipboardFormat(Integer, Integer, TFlxInsertMode, TStream)

Pastes the clipboard contents beginning on cells row, col.

Remarks

See the copy and paste demo.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.PasteFromXlsClipboardFormat(const row: Integer; const col: Integer; const insertMode: TFlxInsertMode; const data: TStream); overload;

Parameters

<-> Parameter Type Description
const row Integer First row where to paste.
const col Integer First column where to paste.
const insertMode TFlxInsertMode How the pasted cells will be inserted on the file.
const data TStream A stream containing a Native xls format.

See also

TExcelFile.PasteFromXlsClipboardFormat(Integer, Integer, TFlxInsertMode, TStream, Boolean)

Pastes the clipboard contents beginning on cells row, col, with the option to convert formulas to their values.

Remarks

See the copy and paste demo.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.PasteFromXlsClipboardFormat(const row: Integer; const col: Integer; const insertMode: TFlxInsertMode; const data: TStream; const convertFormulasToValues: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const row Integer First row where to paste.
const col Integer First column where to paste.
const insertMode TFlxInsertMode How the pasted cells will be inserted on the file.
const data TStream A stream containing a Native xls format.
const convertFormulasToValues Boolean If true, the formulas will be converted to values.

See also