Reading Column Header values from Excel

You can use readexcelsheet() to get data from excel .

then by using that data you can construct CDT,.

load(
local!data: readexcelsheet(
excelDocument: todocument(
123
),
sheetNumber: 0,
startRow: 2
),
a!forEach(
items: local!data.result,
expression: type!cdt(
employeeid: index(
local!data.result[fv!index].values,
1,
null
),
firstname: index(
local!data.result[fv!index].values,
2,
null
),
lastname: index(
local!data.result[fv!index].values,
3,
null
)
)
)
)

You can use readexcelsheet() to get data from excel .

then by using that data you can construct CDT,.

load(
local!data: readexcelsheet(
excelDocument: todocument(
123
),
sheetNumber: 0,
startRow: 2
),
a!forEach(
items: local!data.result,
expression: type!cdt(
employeeid: index(
local!data.result[fv!index].values,
1,
null
),
firstname: index(
local!data.result[fv!index].values,
2,
null
),
lastname: index(
local!data.result[fv!index].values,
3,
null
)
)
)
)

instead of giving startRow:2, have to give startRow:1 and please be maintain cdt structure employee id as string.

I could not see readexcelsheet this option in the expression rule. Do I need to upgrade to newer version?

I believe this is a rule found in the Excel Tools plug-in.