Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
There's also a comment in that thread that says you can use a webApi to export CVS with more columns
from this post https://community.appian.com/discussions/f/plug-ins/14473/export-to-csv-with-more-than-50-columns it looks like the max is 50 columns
Is there any limitations on the number of columns that can be imported by using 'Import CSV to Database'?
Hi Dipti,
Even I am facing the same issue with paginginfo. Could you let me know if you have any solution for this please?
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.