Properties reference: Excel (DataStage®)

Usage

Excel

• Type: category

Write mode

• Type: selection
• Default: Create a file
• Values:
  • Modify an existing file
  • Create a file

Error action

When extracting data from the file, specify how you want to handle errors. Select Fail to abort the job. Select Skip to skip the data and continue to run the job.

• Type: selection
• Default: Fail
• Values:
  • Fail
  • Skip

Excel

• Type: category

Skip null rows

Specify whether you want the stage to skip rows that have null values in all of its cells that are being extracted.

• Type: boolean
• Default: false

Runtime column propagation

• Type: category

Hidden columns

Select Extract to extract hidden columns; otherwise select Skip to skip hidden columns.

• Type: selection
• Default: Extract
• Values:
  • Extract
  • Skip