You are not logged in.
I am using one Excel document with three different sheets as input file and I would like to read each of this sheet one by one instead of all in one go.
I have tried to use regex and to make filter but not working. (see image below) and I am getting error "Exception in component tFileInputExcel_3
java.lang.RuntimeException: Special sheets not exist!"
is anyone having idea how this can be done.
I am not sure if I am clear as when I select sheet by name of course I am getting that sheet , I just thought is posible to read each sheets and to chose which one you want ot read e.g. sheet 1, or 2. or 3
I would like to read each of this sheet one by one instead of all in one go.
Why don't you check the 'All sheets' option? what do you mean instead of all in one go?