When a string column is set as "698.4," exporting it to Excel results in the values being interpreted as dates. Consequently, the exported Excel sheet displays no records. It's important to note that this issue is specific to IQueryable.
- Run the attached sample.
- Put BreakPoint in ReadAsync method.
- Then Filtered the string column with value "698.4".
- The values were exported properly.
- Then, click excel export in toolbar, In read method values were get as date. (Note: Refer the attached image.