清空筛选条件
清空筛选条件

xlswrite without losing precision

2 次查看（过去 30 天）
Susie
Susie 2013-8-23
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!

请先登录，再回答此问题。

回答（1 个）

Anand
Anand 2013-8-24
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 个评论
Susie
Susie 2013-8-26
Thanks. Well, I can see 1.9186e+11, but the point is the original should be 191863214069. I tried to convert it to multiple classes, but none of them worked...
Anand
Anand 2013-8-27
Look at the cell value in the top cell and you will the value in full precision.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by