Getting error while using the function fn!readexcelsheet while uploading a excel file from local machine

Hi All,

I am getting a strange issue that while uploading a excel from  local desktop location and using the same in to  fn!readexcelsheet function getting the below error"Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function fn!readexcelsheet [line 18]: " ; but when I am using the pre-populated rule input which is a Document type input and holding the value of a excel documnt from Appian cloud env not getting any error that time.

So is it that I have to first load the file to local cloud env and then only can use the function ?

Please find my code snippet below:

a!localVariables(
local!document:ri!coverLetter,

local!fileData: if(
isnull(
local!document
),
{},
fn!readexcelsheet(
excelDocument:local!document,
sheetNumber: 0,
startRow: 2,
numberOfColumns: 6
)
),
local!data: if(
isnull(
ri!coverLetter
),
{},
a!flatten(
local!fileData.result
)
),
{
a!fileUploadField(
label: "Cover Letter",
target: ri!targetFolder,
value: ri!coverLetter,
saveInto: ri!coverLetter
),
if(
rule!GHANA_MS_isEmpty(
local!fileData
),
{},
a!gridLayout(
label: "Products",
instructions: "Selected: " ,
headerCells: {
a!gridLayoutHeaderCell(label: "COL 1"),
a!gridLayoutHeaderCell(label: "COL 2", align: "RIGHT"),
a!gridLayoutHeaderCell(label: "COL 3", align: "RIGHT"),
a!gridLayoutHeaderCell(label: "COL 4", align: "RIGHT"),
a!gridLayoutHeaderCell(label: "COL 5", align: "RIGHT")
},
rows: a!forEach(
items:local!data.values,
expression: a!gridRowLayout(
id:fv!index,
contents: {
a!textField(
value: fv!item[1],
saveInto: fv!item[1]
),
a!textField(
value: fv!item[2],
saveInto: fv!item[2]
),
a!textField(
value: fv!item[3],
saveInto: fv!item[3]
),
a!textField(
value: fv!item[4],
saveInto: fv!item[4]
),
a!textField(
value: fv!item[5],
saveInto: fv!item[5]
)
}
)
)
)
)
}

)

  Discussion posts and replies are publicly visible