xlswrite without losing precision
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
Anand
on 24 Aug 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 Comments
Anand
on 27 Aug 2013
Look at the cell value in the top cell and you will the value in full precision.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!