Exporting a sorted delimited file to Excel

Talend Studio allows you to export data to a Microsoft Excel spreadsheet through the tFileOutputExcel component.

Before you begin

You must have added and configured a tFileInputDelimited component (see Configuring a component to read a delimited file).
You must have defined its schema (see Defining a component schema to read a delimited file).
You must have sorted its data (see Sorting a delimited file).

Procedure

In the Designer, add a tFileOutputExcel component.
Right-click the tLogRow component.
1. Select Row > Main
2. Click on the tFileOutputExcel component to link the two.
Double-click the tFileOutputExcel component.
1. In File Name, enter the path and name for the output file.
2. Optional: Select Include Header.
In the Run view, click Run.

Results

The tFileInputDelimited component reads your delimited file, the tSortRow component sorts it, and the tLogRow component displays its content in the console. Meanwhile, the tFileOutputExcel component also exports the sorted data to an Excel spreadsheet.

What to do next

You can choose not to display content in the console (see Disabling a component).

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here