Question

I need to do validation for excel format for different excel

Forum|Forum|1 year ago
December 26, 2024
7 replies
0 views

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.

mathieud0001

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

stefanhelzle0001

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.

iswaryan3555Author

Could please provide the implementation code of the post staging table insertion validation I can use or adapt for me. That would be helpful.

stefanhelzle0001

There is nothing I could share, and the implementation is very specific to your use case.

Sign up

Login with SSO

Login to the community

Login with SSO