Excel Agents UDR Types(4.3)

Excel Agents UDR Types(4.3)

ExcelCellUDR

The ExcelCellUDR type is used to indicate the type of data the cells in a received Excel file contain. 

Info!

ExcelCellUDR fields of Date type can be formatted to a certain date and time format by setting the ec.excel.dateformat property in within the Execution Context. See EC Properties(4.2) for more information about the property.

Field

Description

Field

Description

type (string)

This field the type of data contained in a cell.

value (any) 

This field contains the actual data value in the cell.

ExcelSheetUDR

The ExcelSheetUDR contains a map over all the data in the indicated Excel tab to be processed.

Field

Description

Field

Description

data (map<int,map<string,ExcelCellUDR>>)

This field contains a map over all the included ExcelCellUDRs.

name (string)

This field contains the name of the tab in the Excel file.

ExcelUDR

The ExcelUDR contains a list over all the ExcelSheetUDRs to be processed.

Field

Description

Field

Description

ExcelSheetUDR (list<ExcelSheetUDR>)

This field contains a list of the ExcelSheetUDRs to be processed.