Hi All , I used readexcelimportfile() function for reading the Excel , In excel in one field we provided $ symbol and its failed with error= ERROR:Work item cancelled (Data Outputs).Is there any limitation with filed please provide you input.
a!localVariables( local!read: readexcelimportfile( excelDocument:pv!file, sheetNumber:0, startRow:1 ).result, a!forEach( items: index(local!read,"values",null), expression:'type!{urn:com:appian:types:PST}PST_ListBill_ExcelData'( CaseId:pv!caseId, NAME:index(fv!item,1,null()), REFERENCE:index(fv!item,2,null()), CONTRACT:index(fv!item,3,null()), DATE:index(fv!item,4,null()), ) ))
Discussion posts and replies are publicly visible
I'm not sure where fn!readexcelimportfile() is from, is this a custom function or part of an older plugin? The primary function within Excel Tools is fn!readexcelsheetpaging() and I have not had any such issues with that function.