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

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!

Hey Danny,

I am also new to Appian RPA. I want to read data from excel and process the execution for each row so which course you will recommend us?

Thanks in Advance!!!

Hi,

If you have latest Appian RPA version, then you can explore Excel Data Provider module Low code in Workflow.

Based on my research as of now there is not much docs available for this module as of now.  In case your use case has some specific excel operations which are not supported in this low code module then you can check java api for dataprovider module.

Hi, can you please let me know what is expected in "File Type Parameter" and "Variable".

Also do you know any doc where all these actions are explained. I have searched but did not find any

Thanks,

Mohini