How to know the active sheet

FLX TMS FlexCel for VCL & FMX
1

Hi

When I import an Excel file to a TTXlsFile
            "       Grille := TXlsFile.Create(1, False);
                    Grille.Open(Fichier);"

Is it possible to know which sheet is active in the original xls file ?

regards
olivier
 

2

Grille.ActiveSheet will return the sheet number (1 for the first sheet, 2 for the second, etc)
Grille.SheetName will return the name of the sheet.

To change to a different active sheet, you can do it with
Grille.ActiveSheet := 1; //if you know the sheet number of the new sheet
 Grille.ActiveSheetByName := 'Sheet2' //If you know the sheet name where you want to change.