Skip to main content
pujad918156
March 5, 2024
Question

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)

  • March 5, 2024
  • 2 replies
  • 0 views

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()),
)
)
)

    2 replies

    davidj137213
    March 5, 2024

    I guess that if you remove that field, works as expected.

    csteward
    March 5, 2024

    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.