HotXLS Belgeleri
İçindekiler
Ana sayfa
Genel bakış
TGridToXLS
IXLSWorkbook
Ana sayfa
İçindekiler
Genel bakış
Copy yöntem
Copies a cell or a range of cells to the specified range
Sözdizimi
procedure Copy(Destination: IXLSRange);
procedure Copy(Destination: IXLSRange; CopyMode: LongWord);
Destination
IXLSRange. Belirtir the new range to which the specified range will be copied
CopyMode
Optional LongWord. The part of the range to be copied. Default is xlPasteAll
Açıklama
CopyMode can be one of these XlPasteType constants
xlPasteAll
xlPasteFormats
xlPasteValues
xlPasteColumnWidths
xlPasteNumberFormats
xlPasteValuesNumberFormats
Örnek
This example copies the range A1:D4 on Sheet1 into range E5:H8 on Sheet2
Workbook.Sheets[1].Range['A1', 'D4'].Copy(Workbook.Sheets[2].Range['E5', 'H8']);
This example copies the formats of range A1:D4 on Sheet1 into range E5:H8 on the same sheet
With Workbook.Sheets[1] do begin
Range['A1', 'D4'].Copy(Range['E5', 'H8'], xlPasteFormats);
end;
This example copies the values of range A1:D4 on Sheet1 into range E5:H8 on the same sheet
With Workbook.Sheets[1] do begin
Range['A1', 'D4'].Copy(Range['E5', 'H8'], xlPasteValues);
end;
Copyright © 2010-2026 losLab Software