Example 2: Extracting data from multiple Microsoft Excel sheets

This example uses the sample Microsoft Excel file, Employee2.xls. This sample file has the following sheets: DEPT A00, DEPT B01, DEPT C01, and DEPT D01. Each sheet contains information about the employees in the department.

The data structure of each sheet is similar. Each sheet has the EMP NO, FIRST NAME, MID INIT, LAST NAME, PHONE NO, HIRE DATE, JOB, and ADDRESS columns, and the third row is the header. But each sheet has a different number of rows.