limit no of records in excel sheet

[Anonymous]

hi..
i want to know that is it possible to load the data into excel sheets?
If so then how to load 1-50 records into 1st sheet,51-100 records into 2nd excel sheet and so on up to 5 sheets of a single excel file.
Please help me how to do this..
Thanks..

[Anonymous]

Manoj88,
Isn't this happening because you haven't enabled "Append existing sheet" in the tFileOutputExcel component?
Regards

Actually i've selected the option which u have told.But when I tried after removing ,the last value which came once is repeated fully in all rows for both sheets.

[_AnonymousUser]

Hi Manoj /Shong/Sabrina,
I am unable to see job design 
i have some 10 million records which i want to write in excel sheets , sheet name can be sheet0, sheet1 or sheet2 as it use to be default
i am unable to write in multiple sheets 
can you please show me job design  , i want to implement same as Manoj requirement is " But i need to write data into next sheet once the first sheet gets filled up with data in maximum no of rows(65K).. My input will incrementally increase.."


Thanks
Shivi

[Anonymous]

Hi Shivi  
This job was rather old, I don't have job design any more. Can you please report a new topic for your problem? 
Thanks!
Regards
Shong