topic How to read excel file sheets with different schema structure and load each sheet into a file delimited. in Talend Studio

How to read excel file sheets with different schema structure and load each sheet into a file delimited.

Anonymous — Wed, 03 Apr 2019 12:41:20 GMT

Hi Team,

I have requirement to read excel file sheets with different schema structure and load each sheet into a file delimited. Can you help me components to do this use-case.

Thank You!

Re: How to read excel file sheets with different schema structure and load each sheet into a file delimited.

akumar2301 — Wed, 03 Apr 2019 14:06:45 GMT

Do you know maximum number of column possible ?

If yes , you could read each sheet , as string and send it to file delimiter .

Attaching an example job. For example here I know that Maximum number of column will be 7.

in.xlsx

Re: How to read excel file sheets with different schema structure and load each sheet into a file delimited.

Anonymous — Thu, 04 Apr 2019 12:49:39 GMT

Thanks a lot Abhishek,It did work.