Yeah mate, thats a nasty Excel file hahaha. For me whose is starting in talend were insane to work with.
1) I know that excel contains Merged Cells (the file is sent every month from the partner, if i have to treat the data was not fit to my process)
2) I know that issue, i think this make Metadata confuse and get some errors
3) The same issue i told u on topic 1(if i have to treat data, will not fit to my process)
4) My Job already starts at 8 cell, i know that too .
Lets go,
I need to read All Sheets, because i need all those fields, i was working with one metadata for every Sheet, but reading in tFileList(One file)

There is a way to make "dynamic metadata" to use only one Metadata for all columns of each sheet? I believe u saw that has like 8 Sheets and in some cases 2 Sheets contain the same category of another one.
In the fields were float or something else i changed everything to String with only 2 exceptions(Street Price and Gross Price)
Unfortunally i need to read all sheets in Excel Files(Because need to me Dynamic, if someday i got from Partner the excel which contain "Acessorio" instead of "Acessorios" i will have to make all the whole job again. Imagine to do this job every month
Thanks for all the support everyone gave me in this Issue.
Btw i sent you a private message containing the screenshot of whole job to you see how insane it is.
Warms Regards,