No perfect solution (yet), maybe the Dynamic schema functions in the commercial version of DI are able to do the job here?
I'm currently working on another solution that can read an excel file with an unknown number of rows/columns but this component reads values cell by cell, converting them into key/value pairs, I don't think this meets your requirements.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend