question

MadhanChimmili-0191 avatar image
1 Vote"
MadhanChimmili-0191 asked KranthiPakala-MSFT edited

How to consume merged cells data from Excel through ADF

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

98598-image.png


azure-data-factory
image.png (9.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered

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-MSFT ,@KranthiPakala-MSFT : any thoughts on this or please correct me if I am wrong

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT edited

Hi @MadhanChimmili-0191,

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.


99200-excel.png

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 @NandanHegde-7720 .

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.




excel.png (22.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MadhanChimmili-0191,

Following up to see if the above information was helpful? Do let us know if you have further query.

Thank you

0 Votes 0 ·

Hi @MadhanChimmili-0191,

We still have not heard back from you. Just wanted to check if the above info is helpful? Do let us know if you have further query.

0 Votes 0 ·