HotXLS Docs
Home Contents Overview

Move method

Moves the sheet to another location in the Workbook

Syntax

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

Example

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

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

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