/// <summary>
/// Reads a field, as a string.
/// </summary>
/// <param name="key">The column</param>
/// <returns>The value</returns>
/// <exception cref="InvalidCastException"></exception>
public string GetString(string key)
{
Cell cell = GetCell(key);
if (cell == null)
{
return(null);
}
string result = ExcelCellFormatter.CellToString(cell, _document);
result = result?.Trim( );
return(result);
}
/// <summary>
/// Reads a field, as an integer.
/// </summary>
/// <param name="key">The column</param>
/// <returns>The value</returns>
/// <exception cref="InvalidCastException"></exception>
public int?GetInt(string key)
{
string value = GetCellText(key);
if (string.IsNullOrEmpty(value))
{
return(null);
}
int result;
if (!ExcelCellFormatter.TryParseInt(value, out result))
{
throw new InvalidCastException();
}
return(result);
}