Loading

specific column reader file

mahmudur rifat

10y870.NET

my project mvc 4.i upload xls file.this file read excel reader.i want read column value.Below in my code

while (reader.Read())
{
string post = (reader[1].ToString().Trim());
}

error : Object reference not set to an instance of an object.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amar Gaikwad10y ago
If there is no value present in excel cell then it returns null value. So you need to check if the value retrieved from excel cell is null or not and accordingly write your logic.