inserting data in excel

See more:

C#3.0

C#

Hi all,
I am stuck for many days at this problem in my app...

plz can anyone help me..?

I have an application where a user enters some data in a form1... that data should be displayed on the form2 as well as on excel sheet[same data as form2]..I am able to get the display on form 2.. but not on excel...

Here is my code.. I'm giving 2 methods here...one is for form 2 display[seereport method] and the other is for sheet display[generatereport method]

plz tell me where's the prob.. the first part of both methods is almost identical...

public void SeeReport()
{
                //To display the final report
                for (int i = 0; i < NonRepTasks.Count; i++)
                {
                    Listview1.Items.Add(new ListViewItem(new string[] { NonRepTasks[i],
                                                FinalTime[i], compl[i], status1[i] }));         }
                return FinalTime;
}
          
public void GenerateReport()
        {
            
            
               
                string Connection = string.Format("Data Source='" + docpath +
               @"\Report{0:yyyy_MM_dd}.xlsx';Provider=Microsoft.ACE.OLEDB.12.0; 
                      Extended Properties=Excel 12.0", DateTime.Now.Date);
               
                //for inserting data

                OleDbCommand myCommand = new OleDbCommand();
                string sql1 = null;
                OleDbConnection myConnection = new OleDbConnection(Connection);
                myConnection.Open();
                myCommand.Connection = myConnection;

                //For clearing the sheet data before inserting new data.

                OleDbCommand myCommand1 = new OleDbCommand();
                string sql = null;
                myCommand1.Connection = myConnection;              
                sql = "UPDATE [Sheet1$] set [Task]=null,[Time]=null,[Completion]=null,[Status]=null";
                myCommand1.CommandText = sql;
                myCommand1.ExecuteNonQuery();
             
                for (int i = 0; i < NonRepTasks.Count; i++)
                {

                    sql1 = "Insert into [Sheet1$] values( '" + NonRepTasks[i] + "','"
                   + FinalTime[i] + "','" + compl[i] + "','" + status1[i] + "')";
                    myCommand.CommandText = sql1;
                    myCommand.ExecuteNonQuery();
                }            
                myConnection.Close();

                Process PR = new Process();
                string Filename = string.Format(docpath + @"\Report   {0:yyyy_MM_dd}.xlsx",
                                  DateTime.Now.Date);
                PR.StartInfo.FileName = Filename;
                PR.Start();
                Thread.Sleep(15000);
                Process[] RunningPro = Process.GetProcesses();
                foreach (Process p1 in RunningPro)
                {
                    string s;
                    s = p1.ProcessName;
                    s = s.ToLower();

                    if (s.CompareTo("excel") == 0)
                    {
                        p1.Kill();
                    }
                }
            }