Excel reader Service (com.ibi.agents.XDReadExcel)

Syntax:

com.ibi.agents.XDReadExcel

iIT Service Object:

format: Excel reader

Description: Reads an Excel workbook sheet to XML.

Parameters:

Parameter

Description

Workbook

The full path to the workbook file to be processed. Leave blank to read from the message input stream or bytes form.

DIF *

Determines if this (or every) worksheet top row contain headings.

Sheet Name

The name of the sheet to access. Omit or set to * to read all sheets.

Terminate *

Terminate the agent when an error occurs.

Edges:

The following table lists the available Line Edges for the Excel reader Service (com.ibi.agents.XDReadExcel).

Line Edge

Description

OnError

An exception occurred during execution.

OnSuccess

The operation was successful.

OnFailure

A fail condition occurred during execution.

success

The operation was successful.

OnParseError

Could not parse a document.

OnInvalidFormat

Format of the messages was invalid for the operation requested.

OnNotFound

The resource was not found and this is considered an error.