private static string[] GetRangeHeaders(OpenXmlPart worksheetPart)
{
var count = 0;
using (var reader = OpenXmlReader.Create(worksheetPart))
{
while (reader.Read())
{
if (reader.ElementType == typeof (Row))
{
count = reader.LoadCurrentElement().Elements<Cell>().Count();
break;
}
}
}
return Enumerable.Range(0, count).Select(x => "col" + x).ToArray();
}