Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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
Version 2.10.0 introduced a breaking change which impacts processes using the smart service "Import CSV to Database" where the data source is external. CSV Imports fail with the error: "Error Executing SQL", whereas the same process works fine in version 2.9.0. This issue persists in 2.10.1 also. Requesting clarification if a resolution is known for this issue or if this would be fixed in an upcoming release.
Is Excel Tools Version 2.5.0 is compatible with Appian 25.3?
We are using [Deprecated] Export SQL to Flat File smart service and we recently updated the plugin version to 2.10.0. We tested it is working fine as expected. Do we know if we can continue using this smart service?
We are using the Excel tools plugin to read data from an uploaded excel file into a database table. The plugin is reading the display value of a cell instead of the actual value.
For ex. Display value is 0 for actual value 0.003.
Is there a way to get actual value? please suggest
Do we have any workaround for this problem ? or is there a plugin upgrade or new function that can solve this problem? please share
Version 2.10.0 introduces a breaking change which impacts processes using the smart service "Import CSV to Database" where the data source is external. CSV Imports fail with the error: "Error Executing SQL", which works fine in version 2.9.0. Requesting clarification if a resolution is known for this issue or if this would be fixed in an upcoming release.
Hi Team,Observed a behaviour in the “Import Excel to Database” Smart Service: when we map duplicate Excel header names to different database field names, the import fails with the error “column name cannot be null or empty.”
In our use case, a single Excel header needs to be copied into multiple database fields, but this is currently not possible due to the error.
Could you please verify this behavior and confirm whether it is a known issue? Also, can you confirm whether this will be addressed in an upcoming plugin release?