Hello Everyone,
i am generating excel file and its generating as well only issue is some numeric value format is not correct format and because of that i cannot perform any formula. below snap for your refrence.
Code:
cs.dt = (System.Data.DataTable)dataGridView1.DataSource; System.Data.DataTable dtclone = cs.dt.Clone(); dtclone.Columns[7].DataType = typeof(decimal); //In your case you need to change WaitTime and AssistTime dtclone.Columns[8].DataType = typeof(decimal); foreach (DataRow row in cs.dt.Rows) { dtclone.ImportRow(row); } int b = 0; string[,] dataa = new string[dtclone.Rows.Count, dtclone.Columns.Count]; foreach (DataRow row in dtclone.Rows) { int j = 0; foreach (DataColumn c in dtclone.Columns) { dataa[b, j] = row[c].ToString(); j++; // Thread.Sleep(100); } b++; } xlWorkSheet.Range[xlWorkSheet.Cells[4, 1], xlWorkSheet.Cells[dtclone.Rows.Count + 3, dtclone.Columns.Count]].value = dataa;