xlswrite without losing precision
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a cell array. When I use xlswrite to save them in an Excel file, it will lose precision at some decimal place. For example, if the cell is 191863214069, it will be 191860000000 in Excel.
What I want is to export data as exactly same as it is in Matlab. Anyone knows the solution?
Thanks!
0 commentaires
Réponses (1)
Anand
le 24 Août 2013
You should not be seeing that. I tried the following and the Excel cell shows me the full value:
>> x
x =
1.9186e+11
>> xlswrite(filename,x)
When I open the Excel file I see the value of x with full precision. Maybe you didn't store the value as a double. Check the class of the variable you are exporting.
>> class(x)
2 commentaires
Anand
le 27 Août 2013
Look at the cell value in the top cell and you will the value in full precision.
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!