Is it possible to read a password protected excel?
I tried using function readexcelsheetpaging() as below
readexcelsheetpaging(
excelDocument:<<doc>> sheetNumber:0, pagingInfo:a!pagingInfo(1,-1),
password:"ABCD@1234")
However, I am getting error:
Expression evaluation error at function 'readexcelsheetpaging': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=3,v=ABCD@1234] as java class java.lang.Integer.
Discussion posts and replies are publicly visible
Did you try to pass the parameters in the order as defined by the function? The fourth parameter is an integer.
Thanks @Stefan Helzle , It worked!!