public void SetValue(string cellReference, object value) { #region Validations if (cellReference == null) { throw new ArgumentNullException(nameof(cellReference)); } #endregion var cell = GetCell(cellReference); cell.Value2 = XlsType.FromValue(value); }
public object GetValue(Type type, string cellReference) { #region Validations if (type == null) { throw new ArgumentNullException(nameof(type)); } if (cellReference == null) { throw new ArgumentNullException(nameof(cellReference)); } #endregion var cell = GetCell(cellReference); return(XlsType.ToValue(type, cell.Value2)); }