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!!
Hello,
I'm able to read the excel, But I'm not able to get the data from Excel. Can you please check the below and help me if anything is missing.
I usually use readexcelimportfile() which was working fine, but now due to version incompatibility searching for alternative.
Thanks in Advance
Hi Arun P
Please recheck your mappings as I can see you have added a!pagingInfo in the sheetNumber parameter. and 1 in pagingInfo
readExcelSheetPaging(
execlDocument:<<Doc>>
sheetNumber: 0 <<Sheet number to read from where 0 is the first sheet, 1 is the second sheet>
startRow: 0 <<Row to start reading from , where 0 is start row number>>
pagingInfo: a!pagingInfo(1,batchSize)
)
Hi diptis0002
Sorry, I have uploaded the wrong picture. Can you please check the below image. Still I'm not able to get the data from excel using readexcelsheetpaging, But if you see another image where I used readexcelsheet using which I can able to get the data from excel. I'm not sure if anything is missed.
readexcelsheet is deprecated that why I'm trying to get same output from readexcelsheetpaging
I have resolved my issue now.
Thanks
If you resolved your issue, can you let us know what the issue was and how you fixed it? You may be able to help someone in the future if they have the same problem!
The solution is to change the batchsize to 100 or any max limit , then the function will return results
Eg:a!paginginfo(1,100)