What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface?

Question

What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface? 
 
 Use Case: 
 1) Upload the Excel in the Interface. 
 2) Read the data from the excel.(multiple Sheets - Each sheet will not have more than 10 to 20 rows) 
 3) Show the data in the Interface (Each sheet will be related as one to many relationship) 
 Note: Sheet1 will have parent table data and other sheets will have child table data

davel001150 · Accepted Answer

I personally think the simplest way for that would be to gather the data from excel, then run script tasks on the data as a process variable. 
 You also need to consider what to do if it fails validation. Would you want to present users with an opportunity to download it again?

Manish_Kumar · Answer

Once you upload the excel sheet, you need to pass the document id to Process model so that excel smart service extract the data from it. Once you have the data you can run the validation in appian using a script task (do it only if the dataset is very small ) or do the operation in DB using a Stored proc if the data set is too large.

GopalK · Answer

Hi, You can use readExcel function to read the excel data from uploaded excel sheet and once you have data , it totally depends how you structure your interface. You may consider creating grid to show your data.

Harshit Bumb (Appyzie) · Answer

This is a very common use case. You can use the Excel Tools plugin to achieve this. Find it here - community.appian.com/.../excel-tools

What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface?

Top Replies