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 a 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 Excel Schema Activity:Following are the major subsections:
Section Name | Description |
---|---|
...
Processing a single sheet of an excel file. | |
Processing multiple sheets of an excel |
...
file. | |
Processing unstructured file (excel and pdf). |