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
Hi, in order to use that function the document has to live in Appian, in other words, you have to submit first your interface where you upload the document and then process it