Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Is there any way we can read password protected excel ?
I tried using readexcelsheetpaging(
excelDocument:doc, password:"ABCD@1234, sheetNumber:0, pagingInfo:a!pagingInfo(1,-1)
)
This is giving me 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.
Could you try to pass all parameters in same order - excelDocument, sheetNumber, pagingInfo, numberOfColumns, password, stopReadingAtFirstBlankRow
Hi Dipti,
Even I am facing the same issue with paginginfo. Could you let me know if you have any solution for this please?
Yes it worked!
However facing the same issue as you mentioned:
readexcelsheetpaging function is not returning data when pagingInfo batch size is -1.
Ex:
pagingInfo:a!pagingInfo(1,-1) - not workingpagingInfo:a!pagingInfo(1,50) - working