My codeline is:
Excel excel=new Excel();
Excel excel1=new Excel();
excel.Open(“E:\xue.xls”);
DataTable myTable=new DataTable(“Release”);
myTable.Columns.Add(“lotID”,typeof(int));
myTable.Columns.Add(“pdvID”,typeof(int));
myTable.Columns.Add(“lotPrio”,typeof(int));
myTable.Columns.Add(“dateTime”,typeof(DateTime));
myTable=excel.Worksheets[“release”].Cells.ExportDataTable(0,0,length,4);
DataTable newTable=new DataTable();
newTable=myTable.Clone();
…
newTable.ImportRow(myTable.Rows[deleteRow]);
…
excel1.Worksheets[0].Cells.ImportDataTable(newTable,false,0,0);
excel1.Save(“E:\ReleaseInformation.xls”);
the fourth column’s type is DateTime in xue.xls,but inReleaseInformation.xls it’s the type of string ,how did that happen,how to solve this problem? Thank you!