private string ConvertCellToString(SLCell cell, List <SLRstType> sharedStrings) { // Check if it is a number if (cell != null && cell.DataType == CellValues.String && cell.CellText != null) { return(cell.CellText.ToUpper()); } else if (cell != null && cell.DataType == CellValues.SharedString) { return(sharedStrings[(int)cell.NumericValue].GetText().ToUpper()); } else if (cell != null && cell.DataType == CellValues.Number) { return(cell.NumericValue.ToString().ToUpper()); } throw new ArgumentException( "The given cell is not able to be converted to a String.", "SLCell cell", new Exception( $"Given Cell: {cell.ToString()}")); }
private double ConvertCellToDouble(SLCell cell) { // Check if it is a number if (cell != null && cell.DataType == CellValues.Number && cell.CellText == null) { return(cell.NumericValue); } throw new ArgumentException( "The given cell is not able to be converted to a Double.", "SLCell cell", new Exception( $"Given Cell: {cell.ToString()}")); }