Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hello,
Could you please confirm whether this plugin is compatible with version 24.4?
Thank you in advance.
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.
Current readexcelsheetpaging function will read the display value only. Can we request a new function (eg. readexcelsheetpagingwithRealValue) to get real value ?
Hi Sajai Swaminathan did you find any solution for this.
Good Day Everyone!
I have a messy excel file as a input file and i need only relevant fields from that. Below is the file and need only the highlighted data to proceed further with the process. Can anyone help me on this ?
Desired Output
You can use a connected system with all plugins by using docs.appian.com/.../fnc_system_a_getDataSourceForPlugin.html
I am trying to extract data from an excel but the format it is providing is difficult to parse. Would appreciate some guidance on how to achieve the desired output.
Desired Output:
Hi Paul, could you please let me know the configuration to merge excel. The second excel is not starting from the specified cell position. Even if we mention a cell, the second excel value starts from bottom of first excel
Is there by any chance a version that uses a Connected System instead of a Data Source?
We are experiencing an error/blocker when trying to use the Import Excel to Database smart service. If the table being written to exists in a custom schema we are presented with the following error:
ERROR ImportExcelFileToDatabase (conn=471777) INSERT command denied to user 'appian'@'10.35.118.196' for table `MY_SCHEMA`.`MY_TABLE`