NumberFormat on specific/few columns - Report Generator

5 vues (au cours des 30 derniers jours)
Ali razi
Ali razi le 26 Jan 2022
Commenté : Rahul Singhal le 27 Jan 2022
I am formating a table using this line:
tableData = FormalTable(tableData);
tableData.Border = 'Solid';
tableData.RowSep = 'Solid';
tableData.ColSep = 'Solid';
tableData.Style = [tableData.Style {NumberFormat("%.4f")}];
Is it possible to run the NumberFormat on specific/few columns and not on all the table?

Réponses (1)

Rahul Singhal
Rahul Singhal le 26 Jan 2022
Hi Ali,
You can apply NumberFormat to any specific entry, row, or column in a table. Below are some examples:
%% Apply NumberFormat to a specific entry in the table
entry22 = tableData.entry(2,2);
entry22.Style = [entry22.Style {NumberFormat("%.4f")}];
%% Apply NumberFormat to specific row in the table
row3 = tableData.row(3);
row3.Style = [row3.Style {NumberFormat("%.4f")}];
%% Apply NumberFormat to specific column in the table
colNumber = 1;
for iRow = 1:tableData.NRows
tableEntry = tableData.entry(iRow,colNumber);
tableEntry.Style = [tableEntry.Style {NumberFormat("%.4f")}];
end
Thanks,
Rahul
  4 commentaires
Ali razi
Ali razi le 27 Jan 2022
Modifié(e) : Ali razi le 27 Jan 2022
Thanks a lot it worked.
I also tried to convert the numbers to decimal by replacing to this line:
tableEntry.Style = [tableEntry.Style {NumberFormat("%d")}];
But I go this error:
Error using mlreportgen.dom.NumberFormat
Invalid sprintf value for NumberFormat: %d.
Why?
Rahul Singhal
Rahul Singhal le 27 Jan 2022

Connectez-vous pour commenter.

Produits


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by