Format numerical data in Table within programatic report generation

Question

Justin Solomon 2017-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345408-format-numerical-data-in-table-within-programatic-report-generation

评论： Jan Zelenka 2021-12-17

Hello all, I am generating a report programmatically (pdf) and I'm trying to figure out a simple way to control how the numerical data is formatted when its output into the report. Basically I have a Matlab table, which contains some columns of text and some columns of numerical data. I can easily turn that into a cell array (table2cell) and then use that cell array to construct a table in the document. For example...

 d;  %Handle to document object 
 tab; %This is my matlab table of data
 %Turn the table into a cell array
 c = table2cell(tab);
 %Construct the table
 t = Table(c)
 %append table to the doc
 append(d,t)
 % close the doc (which saves it to a file)
 close(d)

The problem with this method is that numerical data in the table gets printed with full precision and thus has way too many digits (e.g., pi would show up as 3.1415926536 but I'd want something more like 3.14). Is there a simple way to specify that certain columns should be formatted in a specific way, using formatting commands such as those in sprintf()? I know I could loop over each table entry and convert each entry to a string using sprintf(), but I was hoping there was a more elegant/simple way apply numerical formatting options to the whole table at once. I'm relatively novice to programatic report generation so any help is appreciated.

Thanks! Justin

2 个评论
显示无隐藏无

Jeenal Rambhia 2019-4-27

I am facing the same issue. The value in xcel sheet is 0.6 which after reading in report comes to 0.59999999999999 which is not needed. any solution to this is very helpful.

Thanks

Jan Zelenka 2021-12-17

See https://se.mathworks.com/help/rptgen/ug/format_numbers_in_a_table.html

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-6-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345408-format-numerical-data-in-table-within-programatic-report-generation#answer_271219

No, there is not. However, you might want to experiment with using appropriate round() commands on the data before putting it into the document.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Aleksander Karolczuk 2019-7-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345408-format-numerical-data-in-table-within-programatic-report-generation#answer_382295

you can try to convert numeric data to string before table creation. Such as,

a=string(a);

T=table(a);

tbl = mlreportgen.dom.MATLABTable(T);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Carol Smyth 2019-9-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345408-format-numerical-data-in-table-within-programatic-report-generation#answer_390074

I'm having the same issue. Did you find a solution for this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 4

Xudong Zhou 2019-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345408-format-numerical-data-in-table-within-programatic-report-generation#answer_404825

i had the same issue, the number had 0.00000000000000001 added or minused in the table, i used string(number) to fix this problem. hope this can help you.