Is there any configuration available in the Microsoft Excel Input plugin for validating headers?
I tried the following approaches:
1. Read based on the column index
- In this approach, headers cannot be validated.
2. Read based on the column name
- If the column name is not available in the Excel file, it returns a null value. However, I do not want to rely on null values for validation because users may intentionally provide null values, making external validation unreliable.
Currently, we are using modified JavaScript code to validate the headers. However, this approach increases the execution time and impacts the overall workflow/process performance.
Is there any better or more optimized approach available for header validation in the Microsoft Excel Input plugin?
