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.
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.