azharuddim218359

Question

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

Forum|Forum|4 years ago
May 5, 2022
7 replies
0 views

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

Participating Frequently

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.

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

azharuddim218359Author

So Can we access the data within the excel in the interface , after the upload or do we need to pass the excel to process model. and get back the data from the process model?

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.