I am binding an excel column using c#. I need to bind the date column in my excel. There is a constant year already in my excel cell like 1980. I need to append random "mm/dd "to it. I am using Microsoft.Office.Interop.Excel here. i have tried the following code but it lost the constant year value. how can I fix? My cell format in excel is general. I tried different format though.
i am getting like 8/6/System.__ComObject instead of 08/06/1
for (int i = 2; i <= totalRows; i++) { xlWorksheet.Cells[i, 8] = GenerateRandomDates()+ xlWorksheet.Cells[i, 8] ; //not working expected 02/03/1980 } public string GenerateRandomDates() { DateTime start = new DateTime(1995, 1, 1); int range = (DateTime.Today - start).Days; DateTime dt = start.AddDays(gen.Next(range)); int month = dt.Month; int day = dt.Day;string formatted = string.Format("{0}/{1}/", month, day); return formatted; }