Read data from excel using open xml

Hello Ryan,

Please find the sample excel data

Month| Domestic | International
========================
D1 D2| I1 I2
=================================
Jan 12 13 11 9.5
Feb 8.5 7.4 6.5 4.5

Domestic & International columns are the main headers. D1 & D2 are sub header under Domestic. similarly I1 & I2 are under International header


I want to read this data and insert in to data base.

I got stuck in how I can read the columns which are merged.

I saw one sample code
const string testFileName = @"C:\Users\koo\Desktop\test\test\Test.xlsx";
string sheetName = "Sheet1";
using (SpreadsheetDocument document = SpreadsheetDocument.Open(testFileName, true))
{
WorkbookPart wbPart = document.WorkbookPart;

Sheet theSheet = wbPart.Workbook.Descendants<sheet>().Where(s => s.Name == sheetName).FirstOrDefault();

WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id));

MergeCells mcs = wsPart.Worksheet.Descendants<mergecells>().First();

var mcl= mcs.ChildElements.ToList();
foreach (MergeCell mc in mcl)
{

}

}

Will this help to read the merge columns?