Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
I just downloaded the package to find instructions for Wrap_text in the readme file, but it doesn't seem to be mentioned at all - any help?
Thanks Ben Dudley!!
kishore and chandhinir a new version of the plug-in was just released. Please try downloading as it includes a fix that may help!
*Version 1.9.11 - 29May18
- Re-released as a fix was not transferred into the previous release
We have index application where users will download the exceptions into excel and upload it back to appian.We are using "Parse Excel to CDT" plugin to read the excel content into CDT object. However "Parse Excel to CDT" plugin is failing when the excel file uploaded has empty rows at the end. We have upgraded the excel tools plugin to v1.9.11 as i can see from the release notes that the issue is fixed but still we are having the same issue. Can you please help on this
10:30:31,227 INFO [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest) 2018-05-23 10:30:31,227 [Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT -
10:30:31,228 INFO [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest) java.lang.NullPointerException
10:30:31,228 INFO [stdout] (Appian Work Item - 219162 - ProcessExec00 : UnattendedJavaActivityRequest) at com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT.run(ParseExcelFileToCDT.java:155)
Hi,
I am using "Export SQL to Excel" smart service to export the data but getting the error as " The following error was raised by the Export to Excel function: Row 0 has been flushed, cannot evaluate all cells".
I am getting this error when i tried to export more than 100 rows.Can you please check on this?
Thanks in advance!!
Hi wesj , Michael Chirlin updated the readme.pdf with this version of the Excel Tools plug-in. The download file now includes the updated documentation!
*Version 1.9.11 - 15May18
- Adding UTF-8 support
*Version 1.9.10 - 13May18
- Speeding up Export CDT to Excel
*Version 1.9.9 - 12May18
- Removing uniqueness constraint for backwards compatibility
*Version 1.9.8 - 9May18
- Fix bug with blank rows in Parse Excel File to CDT
*Version 1.9.7 - 8May18
- Fix bug with blank date fields failing to parse (Parse Excel File To CDT)
- Fix bug with blank template failing (Export SQL to Excel)
Hey, thanks for the great plug-in! Is there anyway you can update the documentation? Either updating the readme.pdf or provide a URL with the latest documentation would be great, particularly for the Parse Excel to CDT smart service.