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