[resolved] How to iterate over the sheets of an Excel file

[Anonymous]

I have many excel files, each containing a varying number of sheets ; all sheets have the same schema. I want to iterate over the sheets of the various files. I can iterate over the files thanks to tFileList.
I tried to iterate over the sheets with a tJavaFlex component, but apparently the tExcelInput component reads all the data during the begin phase. So I cannot compute the sheet name during the main section of the tJavaFlex...
Is there some way to do that ?
Thanks in advance

[Anonymous]

Hi Laurent,
Thank you for clarification. I have updated my understanding regarding this. To make it more clear, I used tSleep for 5 second and used three links... After 5 seconds all three links executed one after another. First OnComponentOk then RunIf and then OnSubjobOk
Thanks
Vaibhav

[Anonymous]

you're welcome