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 ,
We are seeing issue with Import CSV to Database smart service if number of columns are more than 48 columns.
Do we have any limit in terms of number of columns which can import successfully.
Thanks
We are using Excel Tool v2.2.11. We want to handle a use case where User uploads unreadable / corrupted Excel file from UI using a!fileUploadField(). We are using readexcelsheet() function to read the file but it gives Expression Evaluation Error.
Please suggest how to catch this expression evaluation error thrown by readexcelsheet() function when trying to read unreadable/ corrupted Excel sheet. We want to delete this document (if its unreadable) & show an error message to user that the uploaded document is unreadable.
PFB screenshot showing the error thrown by readexcelsheet():
Any plans to support synced record types for the Import smart services?
Please see community thread here: community.appian.com/.../data-gets-updated-in-db-but-in-record-it-is-not-getting-synced
The Appian Healthcheck is flagging this plugin as high risk; "Excel Tools (com.appiancorp.ps.exceltools) references private and deprecated Appian APIs". Will an upcoming version of the plugin address these findings? Thanks!
Hello!
We are having different issues with the converts one html document to a csv document. We are reviewing the plugging that makes this operation and we fund a mistake in the plugging's source code at ConvertHtmlToCSV.run(). At the insertion of the variable which i responsable for initiating the csv doesn't contain the argument charset, so the special characters of the Spanish alphabet which are included in the html doc, it appears in csv doc like strange characters. We think that the solution to this issue will be changing this sentence:
Are there any plans to support Connected System data sources?
Hi,
As per the Appian https://docs.appian.com/suite/help/23.1/excel-guidance.html#write-data-to-an-excel-workbook , it inform that we can use this write more than 50 columns in the excel. Any suggestion how it can be achieved?
Requesting follow up on whether issue importing date from an Excel file generated by Google Sheets can be processed by Import Excel to Database smart service.
readexcelsheetpaging() this one works quite well, have not used csv ones yet, hope those works too.