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

7 次查看（过去 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 中查找有关 Axis Labels 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by