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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Read merged cells

Thread ID:





124919 Jul 8,2016 11:25 PM UTC Jul 11,2016 12:28 PM UTC WPF 1
Tags: XlsIO
Djordje Radovanovic
Asked On July 8, 2016 11:25 PM UTC

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

Sridhar Sukumar [Syncfusion]
Replied On 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. 
Sridhar S 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon