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

[Anonymous]

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!

[akumar2301 · Accepted solution]

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

[Anonymous]

Thanks a lot Abhishek,It did work.