Excel Tools

• Fixed bug in validatedocumentheader function

I want to store selected column in database, Any suggestion to achieve this

Hey, can anyone elaborate on "Import Excel to Database" smart service and how to use it ?

It indeed does

I think that the latest package already contains the version 1.10.0

This plugin is susceptible to CVE-2022-42889 (Apache Commons Text Remote Code Execution (Text4Shell). Will any future security updates upgrade Apache Commons Text to version 1.10.0?

NVD - CVE-2022-42889 (nist.gov)

• Allow designers to map the CSV headers to database column names
• Allow designers to validate the presence of specific headers in CSV and Excel files

I am using the Export Data Store Entity to CSV smart service to generate a fie that later will be imported into a DB using the Import CSV to Database smart service but I am getting the following error: 

ERROR ImportCsvToDatabase61 Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss' java.time.format.DateTimeParseException: Text '11/17/2022 19:11:00' could not be parsed at index 0

Is there any way to format the date values before exporting the data? 

Hi,

We are seeing below High Risk when we run the health check even after be on latest version of excel tools.

Excel Tools (com.appiancorp.ps.exceltools) references private Appian APIs
[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)

while trying to generate excel through smart node - EXPORT SQL to EXCEL,   
i am getting the below error in process -
The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk.  
And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}