Creating Multiple Sheets In A Single Excel File Using Talend

This blog is about a simple but tricky Talend job where we will be generating 1000 Sheets in one single Excel file using just 1 single record and 1 single sheet as an input. 

The idea of this job is to create a file with 1000 sheets wherein we will be duplicating just one single record in all the sheets.

Note: The records in different sheets can be changed as well.

(If we have to follow a pattern in the change required)

The input and output will be as follows:

Input >                                                                  Output >

We have used one more file (Number Sequence File) which will provide us the range from 1 to 1000. This will help in running the job 1000 times. 

( A file with a single column and 1000 rows, starting from number 1 to 1000)

The components used in the Job are as follows:

• tFileInputExcel (1. Number Sequence File 2. Input File)
• tFlowToIterate
• tMap
• tFileOutputExcel

The job design can be seen in the picture as mentioned below:

The design shows the data flow where we are iterating the job 1000 times and populating the same record in each Sheet. The only change is in the Sheet name. And for that change, we have taken the reference from the Number Sequence File. We have used this reference in the "Sheet name" section while providing the details in tFileOutputExcel component. 

The details can be seen in the picture attached below:

This is how we can generate a Single Excel file with 1000 Sheets. This is one simple method to achieve the goal.