New to Appian, have been through the developer training but have not taken the test yet.
I have a request to be able to upload a Excel file and then parse the data and insert into a table.
I have been looking at the Parse Excel to CDT to do this since this is the option our Appian has.
Trying to wrap my head around this and have been trying to find examples.
Does anyone by chance use this and is there documentation some place for this?
Does anyone have a sample process model showing the steps on how it was done?
Also trying to figure out the configuration on the plugin as well.
Basically the user will upload the excel file, then parse data from excel into CDT then use the CDT to write to the database.
Thank you for any help.
Discussion posts and replies are publicly visible
It seems to me like you might have the most luck with the "ReadExcelSheet" / "ReadExcelSheetPaging" functions available in Excel Tools.
We may have to upgrade to the newest version then, currently we are on a older version and they where wanting to use it. Thank you
"ReadExcelSheet", as far as I know, has been in the plug-in for years. Only in recent versions has it been replaced with "ReadExcelSheetPaging", but i believe either of these would work for you.