Skip to content

Excel¤

Read from or write to an Excel workbook in Open XML format (XLSX). The sheet is selected by specifying it as type in the subsequent workflow operator.

Parameter¤

File¤

File name inside the resources directory.

  • ID: file
  • Datatype: resource
  • Default Value: None

Lines to skip¤

The number of lines to skip in the beginning when reading files.

  • ID: linesToSkip
  • Datatype: int
  • Default Value: 0

Has header¤

If true, the first line will be read as the table header, which defines the column names. If false, the first line will be read as data. In that case, the columns need to be adressed using #A, #B, etc.

  • ID: hasHeader
  • Datatype: boolean
  • Default Value: true

Output object values¤

Output results from object rules (URIs).

  • ID: outputObjectValues
  • Datatype: boolean
  • Default Value: true

Advanced Parameter¤

Streaming¤

Streaming enables reading and writing large Excels files. Warning: Be careful to disable streaming for large datasets (> 10MB), because of high memory consumption.

  • ID: streaming
  • Datatype: boolean
  • Default Value: true

Comments