We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Read merged cells

I have to read sheet with merged cells but not all rows have same merged cells. How can I determine what cells in a row are merged?

Best regards,

Djordje Radovanovic

1 Reply

SS Sridhar Sukumar Syncfusion Team July 11, 2016 12:28 PM UTC

Hi Djordje, 
 
Thank you for contacting Syncfusion support. 
 
XlsIO does not have a direct method to retrieve the merged cells in a row but you can extract the merged cells from a range using IRange.MergeArea property. We have prepared a workaround sample to extract the merged cells from a row which can be download from the following location. 
 
 
Please let us know if you have any queries. 
 
Regards, 
Sridhar S 


Loader.
Live Chat Icon For mobile
Up arrow icon