HotXLS-dokumentation

Move metod

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. Bladet före vilket det flyttade bladet placeras. Du kan inte ange Before om du anger After
After TXLSWorksheet. Bladet efter vilket det flyttade bladet placeras. Du kan inte ange After om du anger Before
lcid Integer. The locale ID

Exempel

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