Import excel into database

Hi [mention:c0e54ea7821d4462a82e8404d41120d1:e9ed411860ed4f2ba0265705b8793d05]

Have you tried the Excel tool plugin?

https://community.appian.com/b/appmarket/posts/excel-tools

You can use one of the two options below, both are provided by the plugin:

• Import CSV to Database
• Import Excel to Database

Hope that helps

Acacio B.

Without the plugin, you would simply read the excel file using native Excel smart services, then convert those to CDTs, do any formatting or other business logic you need to on the CDTs, and write those to the database with Write to Datastore nodes. That allows a little bit more in the way of granular control, but you also want to consider how many excels and of what size, because they'll be converted to Process Variables that stay in memory until the process instances archive. If you are able I suppose the plugin would be the easiest route.