creating multiple sheet in tFileOutputExcel

[Anonymous]

i am using talend openstudio 6.3.  i want to read the employee,department data from oracle data base and data has to be populated into single excel file with 2 sheets ,one sheet for employee and second sheet for department.

what is the use of "Is absolute Y pos" and  append existing file/ append existing sheet option 

[TRF]

Replace tFileOutputExcel by differents tHashOutput not linked one to each other.
Then, add as many subjobs as you have Excel files, using tHashinput (refering the good one tHashOutput) as input flow.
Each subjob linked by onSubjobOk, the 1st one linked to the main subjob.
Sorry for the poor details, just on my mobile.

[Anonymous]

do you have a screenshot maybe?

[Anonymous]

and can the opposite works? I can read from different sheets to the same excel ? I've tried , and it shows like it moving 30 rows but actually the content of the file is empty.

Thank@!

[TRF]

Did you try to tick the "Stop reading on encountering empty rows" option on Advanced settings tab?

[Anonymous]

when I did , it just moved 0 rows

[TRF]

So, if the Excel file contains no row, it's normal, doesn't it?

[Anonymous]

But it does .

when I choose for example only one sheet it "moves" rows on the flow , although the output file is empty

[TRF]

Difficult to explain whithout any access to the input file.
Can you share it?

[Anonymous]

This sounds like it is because you have "activated" the cells but haven't put any data in them. To test this, select the top 100 or so cells from the sheet, right click and select delete. Then re run it.

[Anonymous]

how can I ?