Excel Tools

• Updated the getworkbookandsheetmetadata function to gracefully handle errors like when a Strict Open XML Excel document is provided

Hi there, we are using Excel Tools version 2.8.2. We use the Export CDT to Excel smart service. I see a warning about hte plugin being outdates and I also see 

• Export CDT To Excel (Deprecated)

If we were to update the plugin does that mean that this smart service will no longer be accessible? If so, is there a replacement or alternative suggestion for it?

Hello everyone,

I updated the plugin from version 2.6.3 to version 2.9.0. I noticed that the readexcelsheet() function is no longer present and the new functions in the plugin are not working properly. Could you provide me with instructions on how to replace the readexcelsheet function using the functions of the updated plugin?
I look forward to your feedback.

Post Appian env upgrade to 25.3, "Encrypt Excel with Password" is failing, giving an error as "A folder needs to be provided for this particular configuration".
I have checked we are passing folder id properly and its accessible. Also we have not made any change in the flow, before upgrade it was working absolutely fine.
Appreciate your help.

• Added getworkbookandsheetmetadata function which returns metadata about the excel workbook and the sheets found in the workbook

Hi everyone,

I am looking for a version of the Excel Tools plugin that is compatible with Appian 23.4. I've seen that version 1.8.3 has been mentioned in some discussions, but I can't find it on the official portal.

Does anyone know if it is available somewhere or if there’s a way to obtain this version? Any guidance or suggestions would be greatly appreciated.

Thank you in advance for your help!

what extra configurations do we need for this to work with PostgreSQL? Currently getting delimiter and other errors when using it.

Hi Appian AppMarket ,

Not able to Import the data by Import Excel to Database service with xls format.
Can you please provide the update if smart service supporting the xls format or not? 

Im using the Import CSV to Database smart service, on passing the csv file which has empty values in few cells Im getting the error 'Error executing SQL'. Does the smart service not support csv files with null values for a few cells?

• Fixing bugs associated with library dependencies