How to validate Excel Headers

Anonymous — Sat, 07 Sep 2019 12:42:51 GMT

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/92812

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?

Re: How to validate Excel Headers

Anonymous — Sun, 08 Sep 2019 06:04:53 GMT

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.

topic How to validate Excel Headers in Talend Studio

How to validate Excel Headers

Re: How to validate Excel Headers