Are any of you aware on how to ignore hidden cell values within the tFileInputExcel component? I've searched online and have yet to find anything regarding this. Any help is appreciated. Thanks in advance!
There is no "Ignore Hidden Cells" option in component tfileinputexcel.
For your job requirement, could you please elaborate your case with an example with input and expected output values?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables