How can I read an excel file without approximating values to 4 decimal places?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
MUKHTAR MISBAHU UMAR
am 9 Nov. 2018
Bearbeitet: Stephen23
am 9 Nov. 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 Kommentare
Akzeptierte Antwort
Stephen23
am 9 Nov. 2018
Bearbeitet: Stephen23
am 9 Nov. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!