Hi
I am wondering if it is possible to use the readexcelsheet() function on a rule input file (ri!Submission.submissionfile) which is uploaded in the same interface.
a!textField( label: "Rules", labelPosition: "ABOVE", value: readExcelSheet( excelDocument: ri!Submission.submissionfile, sheetNumber: 1, startRow: 9, numberOfColumns: 4 ).result.values[1,4], saveInto: ri!rules, refreshAfter: "UNFOCUS", readOnly: true, validations: {} )
Should this be possible or does the function only work within a process model?
In the interface I am getting the following error: 'Interface Definition: Expression evaluation error at function 'readExcelSheet'' while in the process model it works (with process variables)
Thanks in advance!
Chris
Discussion posts and replies are publicly visible