How can I get 3 decimals placeś ine the table?

16 次查看（过去 30 天）
Kamil Tomiak
Kamil Tomiak 2017-12-4
评论： Kamil Tomiak 2017-12-5
Hello, I'm new to matlab but and i want my numbers in the table to be fixed to 3 decimal places(right now i get something like 5,5182 e+6) here is my code
if true
% code
dane = xlsread('dane1.xlsx');
nr=['W1';'W2';'W3'];
A=dane(:,1);
B=dane(:,2);
C=dane(:,3);
D=dane(:,4);
app.UITable.Visible = 'on';
app.UITable.Data = [cellstr(nr) num2cell(A) num2cell(B) num2cell(C) num2cell(D)];

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

采纳的回答

Nicolas Schmit
Nicolas Schmit 2017-12-5
Set the column type to char, and use sprintf to format the numbers with the desired number of decimal places.
app.UITable.ColumnFormat = {'char'};
app.UITable.Data = {sprintf('%.3e', 1.2345678e-3)};
  1 个评论
Kamil Tomiak
Kamil Tomiak 2017-12-5
well i used insted of e f to get fix number but it helped me! thanks! app.UITable.ColumnFormat = {'char'}; app.UITable.Data = {sprintf('%.3f', 1.2345678e-3)};

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Get Started with Statistics and Machine Learning Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by