internal static string GetInnerText(this IXLCell cell)
{
_xlCellInnerText = _xlCellInnerText ??
cell.GetType()
.GetProperty("InnerText", BindingFlags.Instance | BindingFlags.Public);
return((string)_xlCellInnerText.GetValue(cell, null));
}
internal static string GetFormulaA1(this IXLCell cell, string value)
{
var type = cell.GetType();
var method = type.GetMethod("GetFormulaA1", BindingFlags.Instance | BindingFlags.NonPublic);
return((string)method.Invoke(cell, new object[] { value }));
}
internal static string GetCellText(this IXLCell cell)
{
var field = cell.GetType().GetField("_cellValue",
BindingFlags.NonPublic |
BindingFlags.Instance);
return((string)field.GetValue(cell));
}