Excel Tools

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.

Hi, we are using import csv to database and it works great also for bigger files, with just one exception. Some of the fields in our CSV (which we unfortunately cannot change) contain quotes inside the text, e.g.:

0000|Some Text|"text in quotes" more text|00|123|6789

which is causing the error message invalid char between encapsulated token and delimiter

when searching the internet I found that in apache csv libraries there is also the option to ignore quotes https://stackoverflow.com/questions/26729799/invalid-char-between-encapsulated-token-and-delimiter-in-apache-commons-csv-libr -> CSVFormat.DEFAULT.withQuote(null)

are these libraries used in the plugin? if yes, would it be possible to add this parameter? this would be of great help for us!

Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content. 

For example:

• Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday"
• Excel Cell Contains "Testing$", then in staging table contains "Testing".

Is anything we missed. Can anyone help on this?          

Our Appian Health Check reported this plugin is using some deprecated APIs. Reading the "Readme" shows you've previously removed some deprecated APIs, is this still on the cards for future releases?