Excel Agents UDR Types

ExcelCellUDR

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

Info!

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

FieldDescription
type (string)

This field is 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 of all the data in the indicated Excel tab to be processed.

FieldDescription
data (map<int,map<string,ExcelCellUDR>>)This field contains a map of 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.

FieldDescription
ExcelSheetUDR (list<ExcelSheetUDR>)This field contains a list of the ExcelSheetUDRs to be processed.