How to change the type of the data?


#1

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!


#2

Could you please send me your xue.xls and releaseinformation.xls? And have you tried the latest hotfix v2.8.5 at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip?