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.
Unfortunately, activation email could not send to your email. Please try again.

Read merged cells

Thread ID:





124919 Jul 8,2016 07:25 PM Jul 11,2016 08:28 AM WPF 1
Tags: XlsIO
Djordje Radovanovic
Asked On July 8, 2016 07:25 PM

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 08:28 AM

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.

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.