HotXLS Belgeleri
İçindekiler
Ana sayfa
Genel bakış
TGridToXLS
IXLSWorkbook
Ana sayfa
İçindekiler
Genel bakış
Move yöntem
Moves a cell or a range of cells to the specified range
Sözdizimi
procedure Move(Destination: IXLSRange);
procedure Move(Destination: IXLSRange; MoveMode: LongWord);
Destination
IXLSRange. Belirtir the new range to which the specified range will be moved
MoveMode
Optional LongWord. The part of the range to be moved. Default is xlPasteAll
Açıklama
MoveMode can be one of these XlPasteType constants
xlPasteAll
xlPasteFormats
xlPasteValues
xlPasteColumnWidths
xlPasteNumberFormats
xlPasteValuesNumberFormats
Örnek
This example moves the range A1:D4 on Sheet1 into range E5:H8 on Sheet2
Workbook.Sheets[1].Range['A1', 'D4'].Move(Workbook.Sheets[2].Range['E5', 'H8']);
This example moves 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'].Move(Range['E5', 'H8'], xlPasteValues);
end;
Copyright © 2010-2026 losLab Software