How to consume merged cells data from Excel through ADF

Question

Please help me how we can read merged cells data from excel in Through Azure data factory

Answer 1

Hey,
Based on my understanding, there is an option called range in the excel dataset wherein you can mention from which row you want to read the data. So in your case you can start from 2nd row to read the sheet.

Else you would have to write a custom code for reading and converting the execl via batch job or Azure function etc.

@PRADEEPCHEEKATLA ,@KranthiPakala-MSFT : any thoughts on this or please correct me if I am wrong

Answer 2

Hi @Madhan Chimmili ,

Thanks for your ask and using Microsoft Q&A forum.

For ADF Excel, it is designed to handle standard tabular data like CSV. If you want to read merged cells, you could try following way to work around it and see if that helps.

Note: Uncheck “first row as header”, then it will auto generate headers (for example, Prop_0, Prop_1....) for your data.

If that doesn't fulfill your requirement, an alternate could be writing your own code and using it in Azure Function activity or custom activity as suggested by @Nandan Hegde .

Hope this info helps. Let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.