expession evalution error while importing excel to interface before submitting

Question

expression evaluation error at "readexcelsheet" 
 readexcelsheet( excelDocument:ri!Spreadsheet, sheetNumber: 1, startRow: 2, 
 ) 
 ruleinput is document

Ujjwal Rathore · Answer

Hi we need to index values as well use the below code in items of for loop and in expression directly use the index. 
 a!localVariables(

 local!excel: readexcelsheet(
 excelDocument:ri!Spreadsheet,
 sheetNumber: 0,
 startRow: 2,



 ),
 a!forEach(
 items: index(local!excel,"result","values",{}),
 expression: {
 ProductID: index(fv!item,1,""),
 VendorID: index(fv!item,2,""),
 ProductCategory: index(fv!item,3,""),
 ProductName: index(fv!item,4,""),
 CurrentPrice: index(fv!item,5,""),
 NewPrice:index(fv!item,6,""),
 PriceImplementationDate:index(fv!item,7,""),
 ReasonForPriceChange:index(fv!item,8,""),
 Comments:index(fv!item,9,"")
 },
 )
) 
 
 you can use code box .

Deepak gupta · Answer

It is giving the error because readExcelSheet is looking for the file and it is not there. Try to do null check for the file.

expession evalution error while importing excel to interface before submitting

Top Replies