writing data to multiple sheets of a single excel file
Hi, 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. Abhineet
Hi, 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. Abhineet
