Documentazione HotXLS

Move metodo

Moves the sheet to another location in the Workbook

Sintassi

procedura Move(Before: TXLSWorksheet; After: TXLSWorksheet; lcid: Integer);
procedura Move(Before: TXLSWorksheet; After: TXLSWorksheet);
procedura 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

Esempio

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]);