MVC Excel Export - Object reference not set to an instance

Question

I was trying to Export to Excel in ASP.NET MVC but I got this error Why am I seeing this error and how do I resolve the problem. See my code as attached.

Ankit Sharma · Answer

Hi Null reference exception occurs if you try to use a value which is NULL. So please check if your model object is getting all the valid data from databse or not. It's difficult to find just by looking at your code. Try putting some breakpoints and trace the code to find the exact location from where this execption is generated. Please visit below links for additional help https://stackoverflow.com/questions/21025792/asp-net-mvc-object-reference-not-set-to-an-instance-of-an-object https://nimblegecko.com/how-to-avoid-and-fix-nullreferenceexceptions-in-asp-net-mvc/

mike idowu · Answer

i is auto-generated serial number. When I comment I the same problem applies to the next file ( COUNTRY_CODE )

Ankit Sharma · Answer

Hi Mike At line 63 your are using i.ToString() inside foreach loop Please check if your variable i holds valid data or not. if the value of i is null then null.Tostring() will be an error.