Posted 15 October 2020, 6:21 am EST - Updated 30 September 2022, 4:20 am EST
Hi,
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.