Losing precision when writing to Excel using xlswrite
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Ollie A
am 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 Kommentare
madhan ravi
am 31 Jan. 2019
instead of writing it into one single file why not write in 3 separate files?
Ollie A
am 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.
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!