How to Read a particular column of excel ?

Hi ,

Please go through the Excel Tools plugin. You can read the excel sheet which is in Appian using a function readexcelsheetpaging in the plugin and from there you can index email column as array of strings

hii there I have tried readexcelsheetpaging but it is not working. the only readexelsheet function Is working but it returns all data in from of list of variants.

hii there I have tried readexcelsheetpaging but it is not working. the only readexelsheet function Is working but it returns all data in from of list of variants.

if we are getting all the details in the excel sheet, then we can use index function to index the particular column and get the required data and if it is in list of variants, use touniformstring() Function - Appian 23.3 to convert that to list of text

Have you tried excelreadcellsbyname() ?

Syntax: excelreadcellsbyname(<Document Id>, { 1 }, { "A1" })

i am getting the data but it is not in proper format

not working

My excel contains below rows

Please index values also after result, it will be as follows

a!localVariables(
  local!data:readexcelsheet(
    excelDocument:todocument(6163),
    sheetNumber:0,
    startRow:0
  ).result.values,
  local!values:remove(local!data,1),
  a!forEach(
    items: local!values,
    expression: fv!item[2]
  )
)

Unknown said:

not working

I wouldn't necessarily expect it to work though since, per your screenshot, you haven't actually supplied the correct parameters for this rule call...

Also it looks as if the Sheet Number for this rule is 1-indexed, not 0-indexed (though annoyingly it doesn't specify in the rule info).  Interestingly the sister function, excelReadCellsByNumber(), does specify this: