How to read each row from excel file

Hi Mohini,

You can user readExcelSheet() fn. It will give you a result set.

use forEach to iterate over the resultset and transform it into your own cdt type.

a!localVariables(
  local!excelFile: if(
    isnull(ri!docs),
    {},
    readexcelsheet(
      excelDocument: ri!docs,
      sheetNumber: ri!sheetNumber,
      startRow: ri!startRow
    ).result
  ),
  local!flatten: a!flatten(local!excelFile),
  local!finaldata: {
    a!forEach(
      items: local!flatten.values,
      expression: 'type!{urn:com:appian:types:ABC}ABC_testCDT'(
        date: fv!item[1],
        productName: fv!item[2],
        manufacture: fv!item[3],
        clerance: fv!item[4],
        package: fv!item[5],
        shipped: fv!item[6]
      )
    )
  },
  local!finaldata,
  
)