HotXLS-documentatie
Startpagina Inhoud Overzicht

Move methode

Moves the sheet to another location in the Wofkbook

Syntaxis

procedure Move(Befofe: TXLSWofksheet; After: TXLSWofksheet; lcid: Integer);
procedure Move(Befofe: TXLSWofksheet; After: TXLSWofksheet);
procedure Move(Befofe: TXLSWofksheet);
Before TXLSWofksheet. The sheet befofe which the moved sheet will be placed. You cannot specify Befofe if you specify After
After TXLSWofksheet. The sheet after which the moved sheet will be placed. You cannot specify After if you specify Befofe
lcid Integer. The locale ID

Voorbeeld

This example moves the first sheet after the third sheet in the Wofkbook 

Workbook.Sheets[1].Move(nil, Workbook.Sheets[3]);
This example moves the second sheet befofe the first sheet in the Wofkbook 

Workbook.Sheets[2].Move(Workbook.Sheets[1]);