Posted 15 October 2020, 6:21 am ESTHi,
We have values like length and Temperature which are of datatype Double.
When we try to open the spreadsheet to load those values into our application few of them are getting converted to DateandTime Format.
We are using the below method to open spread and read the data.
OpenExcel(FileName, FarPoint.Excel.ExcelOpenFlags.DocumentCaching | FarPoint.Excel.ExcelOpenFlags.DoNotRecalculateAfterLoad);
Please provide us assistance in resolving this error.