Precision lost while reading from Excel file to a Matlab table
27 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
JFz
el 31 de Oct. de 2016
Comentada: Walter Roberson
el 31 de Oct. de 2016
Hi,
I am using readtable to read a large high precision matrix from Excel. How to make sure I read the entire decimal points? Thanks,
Jennifer
2 comentarios
dpb
el 31 de Oct. de 2016
How did you determine there was a loss of precision? If the values in the spreadsheet are numeric, then by default readtable will read them as double precision which is the same as what Excel uses.
Show your work and a sample of the data...
Respuesta aceptada
Walter Roberson
el 31 de Oct. de 2016
readtable() will read the entire binary content that is present in Excel.
However, when you display the output of readtable, the output might not show the entire content. The output would depend upon the "format" command that is in effect.
2 comentarios
Walter Roberson
el 31 de Oct. de 2016
This is not a matter of the readtable() 'Format' option.
At the MATLAB command line give the command
format long g
and display the table again.
The default output is "format short" which is only 4 decimal places.
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!