Overview
Provides several smart services and functions for handling data in Excel and CSV formats.
Key Features & Functionality
Smart Services included are:
Functions included are:
Get Workbook and Sheet Metadata
Hi there, we are using Excel Tools version 2.8.2. We use the Export CDT to Excel smart service. I see a warning about hte plugin being outdates and I also see
If we were to update the plugin does that mean that this smart service will no longer be accessible? If so, is there a replacement or alternative suggestion for it?
Hello everyone,
I updated the plugin from version 2.6.3 to version 2.9.0. I noticed that the readexcelsheet() function is no longer present and the new functions in the plugin are not working properly. Could you provide me with instructions on how to replace the readexcelsheet function using the functions of the updated plugin?I look forward to your feedback.
Post Appian env upgrade to 25.3, "Encrypt Excel with Password" is failing, giving an error as "A folder needs to be provided for this particular configuration".I have checked we are passing folder id properly and its accessible. Also we have not made any change in the flow, before upgrade it was working absolutely fine.Appreciate your help.
Hi everyone,
I am looking for a version of the Excel Tools plugin that is compatible with Appian 23.4. I've seen that version 1.8.3 has been mentioned in some discussions, but I can't find it on the official portal.
Does anyone know if it is available somewhere or if there’s a way to obtain this version? Any guidance or suggestions would be greatly appreciated.
Thank you in advance for your help!
what extra configurations do we need for this to work with PostgreSQL? Currently getting delimiter and other errors when using it.
Hi Appian AppMarket ,
Not able to Import the data by Import Excel to Database service with xls format.Can you please provide the update if smart service supporting the xls format or not?
Im using the Import CSV to Database smart service, on passing the csv file which has empty values in few cells Im getting the error 'Error executing SQL'. Does the smart service not support csv files with null values for a few cells?
I am trying to use the Excel to CSV converter but get an error: Convert Excel To CSVAn error occurred in executing an Activity Class.
I specify 1 for Row number ot read from and SHete number. I specify the columns I want to read and for the Excel Document I do a todocument of a DocumentID. In the output I specify a process variable of type Document in which to store AC!CSVDocument.
Any help would be appreciated! It looks like a similar error to the one below (both talk about InputBuilder issues), albeit for a different utility in the Plugin-in.
2025-05-20 00:42:05,363 [ThreadPoolTaskExecutor-182065] ERROR com.appiancorp.process.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [[WorkId: 737, EngineId: execution02, Request: UnattendedJavaActivityRequest:536871033 as roderick.ross@iam-app.co by roderick.ross@iam-app.co, ProcessId: 536889035, ProcessModelId: 1110, Response: null]] - Exception: javax.resource.spi.work.WorkCompletedException: java.lang.NoSuchMethodError: 'org.apache.commons.io.input.BoundedInputStream$Builder org.apache.commons.io.input.BoundedInputStream.builder()' at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:244) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840)