Provides the following custom smart services and functions for handling data in Excel. An example usage application for Export SQL to Flat File is also included.
Smart Services included are:
Functions included are:
NOTE: When deploying this plug-in, please delete all old versions of the ExportableDataSubset CDT AND update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset
Hi, does this version remove the deprecation of the Export CDT to Excel service?
Hello Mike,
Thank You for your answer. Ii know this error coming from POI but in the plug in version 2.2.11 i didn't get the Zip Bomb error.
The reason is in the setting for this variable that by default in the version 2.2.14 shoud be 0.01.
ZipSecureFile.setMinInflateRatio();
If possible could you set this variable to 0 or with the same value used in the version 2.2.11?.
There is nothing to fix, it is working as expected. The error is coming from Apache POI. Please refer to their documentation for potential fixes to your excel file.
I would also suggest trying the readexcelsheetpaging function.
The function should still return the entire data set, it will just read the file in pages. Excel sheet can have a lot of blank rows so this helps with reducing the size of the data read into.
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