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,
  
)

Thanks,

Where should I write this code OR where I can put this file of code.

Also, how the bot will understand which file it needs to read. I have simply uploaded file but did not mention it anywhere

The above example is using Appian expressions with Appian Documents. You don't need to use RPA for this task

Can you please share any link, where all this process is documented. That will be of great help, because this is my first assignment with Appian and I am not familiar with UI as well as terms used in appian

Thanks

Here are the excel tools functions https://community.appian.com/b/appmarket/posts/excel-tools

I recommend going through Appian academy courses to better understand process models and expressions

Thanks!

Thanks!