Skip to main content

Extracting data from an Excel file using a dynamic schema

This scenario extracts data from an Excel 2007 file. It demonstrates the use of dynamic schema.

For more technologies supported by Talend, see Talend components.

The Job in this scenario comprises three subJobs.
  • The first subJob writes data to an Excel 2007 file.
  • The second subJob extracts data from the Excel 2007 file that is used in the first subJob; displays the data in the console; and then writes the data to a CSV file. Note that all the data operations in this subJob are carried out using dynamic schemas.
  • The third subJob extracts and displays the data from the Excel 2007 file in the normal way.

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!