Precision loss during readtable() in excel which is having mixed datatypes

Signal Desciription DataType Dimension Value

AV_Trabs Sigal for trasmssion single [1] 0.620000005

When i Read this data in excel via readtable the data 'Value' gets truncated to '0.62'

Please help me with this issue.

Answer 1

[Rahul]

Hi @Shrikanth s,

I understand that there is a precision loss while displaying data read from ecxel using 'readtable'. Some possible workarounds in this situation couble be:

• Using 'long' format
• Using 'vpa' function

The following MATLAB Answers can be referred:

https://www.mathworks.com/matlabcentral/answers/309976-precision-lost-while-reading-from-excel-file-to-a-matlab-table

https://www.mathworks.com/matlabcentral/answers/403594-how-to-properly-use-vpa-in-matlab

The following MathWorks documentations can be referred to know more:

'format': https://www.mathworks.com/help/matlab/ref/format.html

'vpa': https://www.mathworks.com/help/symbolic/sym.vpa.html

Thanks.