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.

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

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