Excel Agents UDR Types

Excel Agents UDR Types

This page describes the User Data Records (UDRs) used by the Excel encoder and decoder agents. These UDRs define how data from Excel files is structured and processed, including details for individual cells, sheets, and entire workbooks.

ExcelCellUDR

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

Note!
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. For more information about the property, seeExecution Context Properties.

Field

Description

Field

Description

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.

Field

Description

Field

Description

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 of all the ExcelSheetUDRs to be processed.

Field

Description

Field

Description

excelSheetUDR (list<ExcelSheetUDR>)

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



Scroll Pagebreak