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. 

There are two methods of processing an excel sheet using Excel Schema Activity:Following are the major subsections:

...

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).