Move method - HotXLS Developer Reference

Moves the sheet to another location in the Workbook

语法

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

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