Loading Data into Excel using Talend

Scenario:

Load data into Excel and make the first column in the data into Upper case using Talend Open studio.

Job:

Procedure:

1.       Create a job and give a name “job_excel_load”.

2.       Load data into Talend Open studio using the component tFileInputDelimited and configure schema a below

 

To make transformations on data the component tMap is used and it is connected to tFileInputDelimited rowàmain.

4.       To convert the first column of the data into Upper case, the string handling function UPCASE in the tMap is used.
UPCASE: Converts all lowercase letters in an expression to Uppercase. 

5.       To load output into excel the component tFileOutputExcel is used and connection is given to tMap.

6.       The tFileOutputExcel component is configured as below.
The output file name is given with an extension “.xlsx”

7.       Run the Job.

Output:

Output Sample: