Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
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?
We are using MS SQL Server 2017, we've had no success with either Import Excel to Database or Import CSV to Database but we have had a true error message output when we've tried Load CSV to Database saying it's only compatible "This method only works with MySQL databases". Could you give us some feedback on the compatibility of this plugin?