changing the position of worksheet in a workbook

[kjteng]

Is it ok to change the position of worksheet by changing the worksheet.index property. For example if I have a workbook (wbk) containing 3 worksheets with name 'one', 'two', 'three'. then I can move worksheet 'one' to the last postion as follows:
  sht := wbk.GetWorksheetByName('one');
  sht.Index := 3
Is this a proper way to move the worksheet?

[cdbc]

Hi
I would expect a 'Move' procedure, to be present?!?
Regards Benny

[paweld]

Code: Pascal  [Select][+][-]

1. var
2.   workbook: TsWorkbook;
3.   worksheet: TsWorksheet;
4. begin
5.   workbook := TsWorkbook.Create;
6.   workbook.ReadFromFile('data.xlsx');
7.   worksheet := workbook.GetFirstWorksheet;
8.   worksheet.Index := 3;  //set as fourth  

[kjteng]

Thanks all for your reply.

Benny,
I dont think there is 'move' procedure for fpSpread. Though there is a movesheet method (protected method) which is called whenever we set the index property of a worksheet.

paweld,
Your code is the similar to what I did... except that it only moves the first worksheet to the end ( where mine moves any named sheet to end). I have tested this method with few small example and found it works. What I wish to confirm is whether this is the correct way (that do not have other 'side effect')  to move worksheet within a workbook. 

[paweld]

What I wish to confirm is whether this is the correct way (that do not have other 'side effect')  to move worksheet within a workbook.

Yes, this is the right way to move the sheets. If you specify an index out of range, it will be detected and corrected (set as the first or last sheet)

[kjteng]

tqvm