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,
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 even with the limit set to 100 rows. Any advice would be appreciated!
Thanks.
Hello, Does anyone have an example (recipe) for using the "Import Excel to Database" Smart Service? Thanks --Greg
Hi sandhyam0001 and amitb0004 - I would suggest posting in Discussions https://community.appian.com/discussions/ if you have a question. Your question will get the most visibility that way!
while importing application it gives me an error>>>
"The specified file does not contain a valid package and cannot be imported. (APNX-1-4154-000)"
Hello,
Could you please redirect us to latest documentation/readme.pdf?
Hi Corrado de Candia where can we find more documentation of the plugin? Like a User Guide. Thanks !!!
When will you re-add the ability to take an arbitrary set of data, do appian-side processing/transformation to it, and write the result easily to an Excel file complete with word wrap enabled on the written cells? The only previous way to do all of this was the Export CDT to excel, now removed, with no functional replacement at all.
I know I could create a scrap DB table with arbitrary text columns and write data to it, then invoke it with the SQL to excel smart service, but even this super cumbersome approach still doesn't (as far as I'm aware) contain the way to set / preserve word wrap on filled cells.
We have upgraded to the latest version of this plug-in and encountering 'ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase - Invalid object name' issue for the tables that were defined under a schema. It was working before. Kindly resolve the same.
Can we add documentation for the new functions and smart services added? THe one included does not have docs for Import Excel to Database
* Version 2.2.0 - 09 Nov 18
- Added Convert Excel to CSV Smart Service
- Added Import Excel to DB Smart Service
- Added LOAD CSV to DB Smart Service - fast CSV import for MySQL database that are not hosted on Appian Cloud
- Import CSV to DB can now decrypt EncryptedText fields (for importing into external DS)
- Deprecated CDT to/from Excel, Export Report, Export Excel Servlets (existing use will continue to work)