Precision in writetable()

87 次查看（过去 30 天）
madhan ravi
madhan ravi 2020-10-26
评论： dpb 2025-4-16
Is there a way to use writetable() to export using only 2 decimals? To be able to directly export it to an excel file.

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

采纳的回答

dpb
dpb 2020-10-26
Sadly, no. A OutputFormat formatting string or NumericPrecision option is not available.
I presume since a table can contain any data type including cells too many possibilities are opened up that TMW hasn't wanted to venture down that road.
Does seem like worthy of some design consideration for the normal cases, though, granted...
For text files, the numeric format is long g.
  7 个评论
显示 5更早的评论
Tao Wang
Tao Wang 2022-3-10
For me , Willingo's answer is still not working.
I tried and it did show numbers with 2 decimals in commond . but if I writetable() to excel, the numbers format is still long.
Also , I tried num2str first ,
num2str(1.345,'%.2')
and u will not only get the data with 2 decimals ,but also a green flag on the top left of the box.
dpb
dpb 2022-3-10
Because having rounded the numbers, they still are doubles and will have machine-precision rounding that Excel will try to preserve.
All you can do is format them inside Excel; same way as MATLAB, Excel keeps everything as a double internally; it only changes how they're displayed.
The second route writes the numeric value as text in the cell which is the source of the warning highlight.
There are several user-contributed utilities to allow one to set Excel table properties on the FEX. I believe it was @Image Analyst who wrote and posted a pretty nice starter set of Excel_utils that you may search for here on Answers -- I recall making a couple extensions and adding/posting another feature or two. That's been with the year...just at the moment I've got things in a state it isn't convenient to try to go find, but will try to get back...

请先登录，再进行评论。

更多回答（2 个）

Johannes Kalliauer
Johannes Kalliauer 2022-7-20
编辑：Johannes Kalliauer 2022-7-20
You could use dlmwrite: https://www.mathworks.com/help/matlab/ref/dlmwrite.html
dlmwrite('yourfile.txt',t{:,:},'\t','precision','%10.2f')
  1 个评论
dpb
dpb 2022-7-20
Doesn't get OP directly to Excel as per request, though...but correct that it does allow the formatting string.

请先登录，再进行评论。

Christine
Christine 2025-2-12
Another workaround might be executing this line for the variables inside the table.
variable = round(variable*100)/100;
  2 个评论
Adam Danz
Adam Danz 2025-4-16
Ran in:
Use Y = round(X,N) to specify the number of decimal places.
Instead of
round(pi*100)/100
ans = 3.1400
use
round(pi,2)
ans = 3.1400
dpb
dpb 2025-4-16
Ran in:
Another I've seen has been
str2double(sprintf('%.2f',pi))
ans = 3.1400

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by