As per my requirements i need to write data into different sheets of a same excel file. I used multiple tFileOutputExcel components in a single job by passing different sheet names as context variables. But I realised that in a single job if multiple tFileOutputExcel components are used data is being written only to the last sheet.
Is there a way to handle this in a single job?
Thanks in advance.