Kettle provides the Excel input step, in order to read data from Excel files. In this recipe, you will use this step to read an Excel file regarding museums in Italy. The file has a sheet with one column for the name of the museum and other for the city where it is located. The data starts in the C3 cell (as shown in the screenshot in the next section).
For this example, you need an Excel file named
museumsItaly.xls with a
museums sheet, as shown in the following screenshot:
You can download a sample file from the book's site.
Carry out the following steps: