How to identify ranges of merged cells in excel using c#

Question

How to identify ranges of merged cells in excel using c#

Answer 1

Great that you succeeded.
Which method did you use to read the excel file.
The microsoft.interop ?

Answer 2

yes.

Answer 3

Range has a boolean property MergeCells
This indicates if cell has been merged.

if (objRange.MergeCells){    data[col - 1] = Convert.ToString(((Range)objRange.MergeArea[1,1]).Text).Trim();}else{    data[col - 1] = Convert.ToString(objRange.Text).Trim();}

http://www.c-sharpcorner.com/UploadFile/17e8f6/reading-merged-cell-from-excel-using-microsoft-office-intero/