Com object is not binding using Microsoft.Office.Interop.Excel in c#

Sujeet Raman

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;
}

3 Replies

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

Sachin Singh5y ago
Accepted answer
after the code have you changed the format? if not then modify it as
xlWorksheet.Cells[i, 8].NumberFormat = "MM/DD/YYYY";
Sujeet Raman5y ago
System.FormatException occurred

error: input string is not in correct format
Sachin Singh5y ago
test this
public string GenerateRandomDates(int year)
        {
            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}/{2}", month, day,year);
            return formatted;

        }

for (int i = 2; i <= totalRows; i++)
            {
               int c=Convert.ToInt32(xlWorksheet.Cells[i, 8].Value.ToString());
                xlWorksheet.Cells[i, 8] = GenerateRandomDates(c) ;


            }