Skip to Content (Press Enter)
UserImage.jpg
Prachi Dalal
264Views
2Comments
Solved
Check the uploaded excel file template
Question
Reactive
Data
File
Application Type
Reactive

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

0
0
08 Jul 2021
Copy Link
2021-11-18 18-03-41
AJ.
Solution

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,

Regards,

AJ

ExcelHeaderValidation.oml
0
0
09 Jul 2021
Copy Link
UserImage.jpg
Prachi Dalal

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

0
0
09 Jul 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.