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.
Following are the major sub sections:
| Section Name | Description |
|---|---|
| Learn how to process single sheet of an excel file. | |
| Learn how to process multiple sheets of an excel file. |