HotXLS-dokumentation
Innehåll
Startsida
Översikt
TGridToXLS
IXLSWorkbook
Startsida
Innehåll
Översikt
Copy metod
Copies a cell or a range of cells to the specified range
Syntax
procedure Copy(Destination: IXLSRange);
procedure Copy(Destination: IXLSRange; CopyMode: LongWord);
Destination
IXLSRange. Anger 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
Beskrivning
CopyMode can be one of these XlPasteType constants
xlPasteAll
xlPasteFormats
xlPasteValues
xlPasteColumnWidths
xlPasteNumberFormats
xlPasteValuesNumberFormats
Exempel
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