How to include a condition to check if cell value in column is empty?

Question

How can I include a condition to check a excel cell column value to see if it is empty or not? I've already mapped the column using linq mapping. When I go to grab the value whether it is null or not in the excel file, i'm getting object not set to reference error. Any help is appreciated. Here's what I got:

 public class Test
 {
 public string excelValue { get; set; }
 }

 string excel = @"C:\excel.xls";
 var excelFile = new ExcelQueryFactory(excel);
 excelFile.AddMapping<ExcelClass>(p => p.excelValue, "Name");
 var getvalue= excelFile.Worksheet<excelClass>("Sheet1").ToList();
 return getvalue;

public string GetMyName(List<excelClass> nameValue)
{
//NEED TO CHECK BEFORE SENDING TO A STRING VARIABLE!!!!!

string name = nameValue[1].excelValue.ToString();
return name;

}

`string.IsNullOrEmpty(excelValue)` will return false if there is a value and true if it's null or empty. — Bardicer, Jun 25 '15 at 21:51

score 1 · Accepted Answer · answered Jun 25 '15 at 21:55

1

You can't call a method on a null object, whether it is ToString() or anythig else.

if(nameValue[1] != null)
{
   if(nameValue[1].excelValue != null)
   {
       return nameValue[1].excelValue.ToString();
   }
}

answered Jun 25 '15 at 21:55

Crowcoder

11,250
3
36
45

`HasValue` is only available on nullable value types. – Crowcoder Jun 25 '15 at 22:04
If i wanted to put that into a method and still use ".excelValue" as it changes, how would I do it? private static string GetName(nameValue, index)? where would the class "excelValue" go in the parameter? – NewKidOnTheBlock Jun 26 '15 at 13:19
@NewKidOnTheBlock I don't quite understand. Maybe you could start a new question. – Crowcoder Jun 26 '15 at 14:14

How to include a condition to check if cell value in column is empty?

1 Answers1