You can use an Excel Schema activity to define how to read data from and write data to an excel file. To do so, you need to specify the name of the excel sheet and enter data in the required fields, to enable identification of those fields. While creating an Excel Schema you can also define hierarchy (parent-child relationship) between the records. You can define a parent-child relationship only when you create the schema using data file.
There are two methods of processing an excel sheet using Using an Excel Schema Activity, you can:
- Process an excel file with single sheet
- Process all sheets of an excel fie