Losing precision when writing to Excel using xlswrite
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi all, I have a matrix on MATLAB with a very percise values, such as: 2 .268073544251674e+03 but when converting to excel it only shows: 2268.1
I used the following command:
xlswrite('MatrixEvoUNSuc',EvoUnsuc)
Is there anyway I could make sure I don't lose that percision?
Thank you!!
0 commentaires
Réponses (1)
Ollie A
le 31 Jan 2019
It could be to do with the format of the excel cells. In excel you can increase the number of decimal places displayed.
Otherwise, I tried:
T = table(EvoUnsuc);
writetable(T,'MatrixEvoUNSuc.xls');
which seems to display the number to a higher precision.
8 commentaires
madhan ravi
le 31 Jan 2019
instead of writing it into one single file why not write in 3 separate files?
Ollie A
le 31 Jan 2019
I would try writing the data to a .dat or .txt file instead of .xls.
Reading the data back will be just as easy, and I'm sure the different file format will store all of your data.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!