Check the uploaded excel file template
Application Type

Hi all ,

I've a use where a user  needs to do an excel upload . The user can first download the excel template which has all he headers and populate it with the data required and do an excel upload . I want to check weather the uploaded excel  has the correct template or not . What is the best way to do that . I have used cell read in the advanced excel component but this excel has more than 50 headers .

Thanks & Regards


Hello Prachi,

If the header row is all you want to validate between the template and the uploaded file, then the attached oml will do it.

I used Advanced Excel forge component actions to read the header cell values and concatenate them into a single string. Then I compare the Template header string and the Excel header string to validate.

I processed a 100 column template and excel file without issues.

Basically you should get the general idea and be able to tweak the logic as desired.

Hope this solves it,




Thanks AJ  I was able to use this logic for my usecase

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.