Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
If you are looking for documentation, just download the plugin. It includes a "readme.pdf".
Hello. I see here a lot of questions with no answers. Isn't there anyone supporting this plug-in? Please could anyone indicate if any documentation or use notes exist? So we don't have to make the crash course to make it work? For sure something can be found in youtube, but it would be better some indications from the official site.
thanks ;)
Has anyone encountered issues when their Excel file was generated with Google Sheets? When attempting to use Import Excel to Database, when the Excel file was made with Google Sheets the data is not being extracted from the document into the database table.
Hi Paul, can you expand a bit more on this? Do you see any exception in the logs?
What is entailed in a Security Update for the plugin? Working through an analysis of the plug in and looking for any additional details as to what is updated as part of the security updates.
Is this plugin supports Postgre DB? As I'm facing below issue while using "Import CSV to DatabaseV6"
2023-01-16 09:50:08,138 [Appian Work Item - 1389872 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase61 - Error executing SQLorg.postgresql.util.PSQLException: ERROR: syntax error at or near "`" Position: 15
Hi, Just updated to 2.4.1 on appian 22.4 have been successfully using the Import Excel to Database smart service on previous versions of this plugin.
The behaviour of the smart service has now changed in that the first empty row encountered causes the import to end.
.Is there a way to overcome this behaviour i.e continue past empty line?
Regards
I want to store selected column in database, Any suggestion to achieve this
Hey, can anyone elaborate on "Import Excel to Database" smart service and how to use it ?