I need to do validation for excel format for different excel

Question

Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity . 
 Is there any way to do that. 
 Can anyone suggest a way and how to implement it.

Mathieu Drouin · Answer

It depends on what the Excel files look like but you should be able to accomplish this by using the 
 
 Read Excel File Paged 
 Read Excel Cell by Name 
 Read Excel Cell by Number 
 
 From the Excel Tools plugin: community.appian.com/.../excel-tools

Stefan Helzle · Answer

This depends a lot on how you want to implement this validation. A real validation would always mean to first read all data, and then run a validation rule. Out of scalability considerations, I typically import all data into a staging table first. The next step would be your validation, followed by a transformation step using a stored procedure.