Read Password Protected Excel

Certified Senior Developer

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

Parents Reply
  • 0
    Certified Senior Developer
    in reply to Arun P

    Hi

    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)

    )

Children