We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Error in date format while converting from csv to excel

HI team
We have noticed a discrepancy when the CSV file was converted to excel. In our CSV file, we have a date of birth field and we are converting the CSV file to excel we have noticed the date of birth was appearing in excel as 11/05/2052 whereas the value in CSV was 11/05/1952
dll: Aspose.Cells
Version : 8.1.0.0

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(fInfo.FullName, loadOptions);
workbook.Save(Path.Combine(emailImagesFolder, name+ “.” + PadValue.ToString().PadLeft(3, ‘0’) + “.XLS”), Aspose.Cells.SaveFormat.Excel97To2003);

@anishvj,

Please zip your input CSV file and output XLS file and attach here, we will check it soon.