How to validate Excel Headers

[Anonymous]

I need to know if the Excel file which is being processed has header names same as per the expected sequence. If the header names are different I need to stop job with an error captured in tLogCatcher. If the header names are same as per the expected sequence then the file is supposed to be processed further.

@umeshrakhe  I referred the post: https://community.talend.com/t5/Design-and-Development/How-to-check-csv-header-names-are-valid/td-p/...

But tFileInputFullRow works for CSV file for Excel it prints garbage values. Is there a way in Talend to capture all headers of Excel File as a Single Row?

[Anonymous]

Excel will not give you all columns as a full row instead you have to parse
each sheet and convert them to csv, psv and flow the rest.

Using dynamic schema you directly read all columns the draft them in csv,
psv and then again follow rest of the post.