Hi All,
I have a requirement that to read excel file and display the unique data in the interface.
Can anyone suggest the best approach for this requirement?
Thanks & Regards,
saidivya Minna.
Discussion posts and replies are publicly visible
HI, You can use excel tool plugin to read the excel. Below are the functions under excel tool plugin
further you can check out the plugin https://community.appian.com/b/appmarket/posts/excel-tools
Depending on the size in columns and rows, it might be a better idea to write the excel to DB, transform it using a stored procedure and then make it available to the user.