Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

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. 

Using an Excel Schema Activity, you can:

Following are the major subsections:

Section NameDescription

Process an excel file with single sheet

Processing a single sheet of an excel file.

Process

...

multiple sheets of an excel file

Processing multiple sheets of an

...

excel file.

Processing Unstructured File

Processing unstructured file (excel and pdf).