Example 1: Extracting data from a range in an Microsoft Excel file

This example uses the sample Microsoft Excel file, Employee1.xls, which contains details of employees working in an organization. This sample file has three spread sheets, Sheet1, Sheet2 and Sheet3.Sheet1 contains information about the employees in every department in the organization. Sheet2 and Sheet3 are blank. In this example, you extract business information about only the employees who work for department B01.