Read merged cells

[Djordje Radovanovic]

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]

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. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReadMergedCells-1512078005.zip 

 

Please let us know if you have any queries. 

 

Regards, 

Sridhar S