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 Mike, we have used this plugin in our application. In light of the recent discovery of vulnerabilities with log4j2, we would like to know if this plugin uses the affected version Log4j2, and if yes, would you release an updated version of this plugin to counter the exploit of vulnerability?
Arun, has your issue been resolved?
How to configure import excel to database smart service?
getdatasubsetdownloadlinkfromprocess this function is deprecated from the latest version of excel tool(2.2.16) plugin.
Please suggest if any alternative is available.
How can I use the "Query Appian Logs" function?
Hi All,
I get the below message in the health check report and we have the latest Excel Tool plugin 2.2.15 with APPIAN 21.3
"Excel Tools (com.appiancorp.ps.exceltools) references private Appian APIs[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)"
Could you please let me know , why am i getting this error even with the latest excel tool plugin?
Has anyone had any joy with using the function queryappianlogs in a High Availability environment ? It seems to be limited to only retrieving the logs from the application server where the user is using the function ? If this is a current limitation are there any plans to enhance the plug in to pass in the log path as per the Log Reader plug in ?
When using the 'Convert Excel to CSV' smart service in a process model, the node is failing when given an OOXML Excel file. It appears to be an issue with the Apache poi libraries not supporting OOXML files.
Is there any workaround to this? I've tried configuring the error output of the node to display an error message to the end user but it appears that the node fails before it can even write the error output. I also can't think of any way to check the file type in the process as the file extension of the OOXML Excel is identical to that of a regular Excel.
Check the encoding on the CSV file you are giving it - I had the same issue until I swapped the encoding from UTF-8 BOM to UTF-8.