Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
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`
Hi, we are using Import Excel to Database in which I am giving dates in a column to store in database in a format of 1986-09-21 i.e "yyyy-mm-dd" and its storing in database in exact format but changing the date values from the exact one which I am giving in database.Can anyone help on this ?
merge excel doesn't work. We are trying to combine 2 excel data with same number of columns but still output is not showing any thing. Though cofniguration and excel are correct. It is always generating second excel as it is.