Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
We just tried updating the plugin and discovered that this plugin was indeed removed. This breaks all our entity-backed record grid export to Excel links. I understand that the out-of-the-box feature on recordType-backed grids includes export to Excel, but there is not a 1-to-1 conversion with regard to filters and look-and-feel, and there is high effort to upgrade all our grids. For now we will have to continue using the old version of this plugin.
Hi is this plugin still supporting.
Goodmorning
using the function excelreadcellsbyname in file more than 500kb i get the error below:
ERROR com.appiancorp.ps.exceltools.util.ExcelHelperUtils - Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data.
Please could you fix the plugin?
Thank You
Gianluca
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
Could you try to pass all parameters in same order - excelDocument, sheetNumber, pagingInfo, numberOfColumns, password, stopReadingAtFirstBlankRow
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.
We were relying on this plugin to be able to export entity-backed reports to Excel. Is this function still included?