Reading Excel file dynamically with metadata present in .csv file

[Anonymous]

Hi Team,
I have an Excel with data, having below structure.
Name Phone Email
ABC 9123456789 ABC@gmail.com

and in another Text file (structure.csv) I have the "Excel structure" as 
Name,Phone,Email

Is it Possible to read the Excel file, by using the "Excel structure"(structure.csv) present in Text file ?
without hardcoding the schema in the tFileInputExcel component by referring the "structure.csv" file . 
As there may be different structure for different excel with metadata present in Text file.
Can this be achieved in Talend open studio (Free version)

Thanks,
Raj

[Anonymous]

Hi,
So far, there is no dynamic schema feature in tfileinputexcel component. Do you want to read a excel file with unknown column structure?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Yes I want to read the Excel without defining the schema structure.
But the structure of Excel would be present in .csv file to refer .
Let me know if you require any other information.
Regards,
Raj

[Anonymous]

Hi Sabrina,
Any updates?

Thanks,
Raj.

[Anonymous]

Hi,

But the structure of Excel would be present in .csv file to refer 

You have to design your schema structure at design time not run time.
Best regards
Sabrina