How can I read an excel file without approximating values to 4 decimal places?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
MUKHTAR MISBAHU UMAR
el 9 de Nov. de 2018
I read an excel file as part of my code but the particular values I am interested are approximated to 4 decimal places instead of the higher places I would want to have. These are latitude and longitude values and every digit is important. Is there a way I can read all decimal places with any approximation?
This is in R2018b.
0 comentarios
Respuesta aceptada
Stephen23
el 9 de Nov. de 2018
Editada: Stephen23
el 9 de Nov. de 2018
MATLAB does not "approximating values to 4 decimal places" when reading file data, that is simply how the values are being displayed. Do not confuse how values are displayed with what values are actually stored in MATLAB memory: these are two quite different things! You can change how values are displayed by using the format function, e.g. run this in the command window:
format longg
then display your data again. Try other format options and pick one that you like.
If you are using the Variable Viewer then change its format options.
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!