How can I export a Matlab 2D array in Conditional Formatted table in pdf using MATLAB Report Generator?

Question

I have some 2D arrays in Matlab. And I wanted to export this array in pdf in 3 Colour scheme Conditional Formatted (Mostly used function in Excel) Table as shown below. How can I do that in MATLAB?

I have written a script to do that. But I can't debug what I am doing wrong.

addpath('hex_and_rgb_v1.1.1')
addpath('colorGradient')
format short

z=[
0.1 0.2 0.3;
0.5 0.6 0.7;
0.8 0.9 0.10;
];


zt = reshape(z.',1,[]);
 [~,idx] = sort(zt,'ascend')

gradblue=colorGradient(hex2rgb('#0d77c3'),[1 1 1],size(z,1)*size(z,2)); %blue
gradred=colorGradient([1 1 1],hex2rgb('#fe0a0b'),size(z,1)*size(z,2)); %red 


import mlreportgen.report.*
import mlreportgen.dom.*
rpt = Report('zebraTable','pdf');
formattedNumbers = arrayfun(@ (n) sprintf("%1.3f", n),z);
tb = Table(formattedNumbers);

% Conditional formatting for table entries
nRows = tb.NRows;
nCols = tb.NCols;
num=0;
for iRow = 1:nRows
    for iCol = 1:nCols
       num=num+1;
        entry = tb.entry(iRow,iCol);
        entryContent = entry.Children.Content;
%plot([1 2 3],[1 2 3],'*-','color',gradblue( idx(num),:) )
        % Provide as many cases you want based on the entry content value
        if str2double(entryContent)<0.5
            entry.Style = {BackgroundColor(rgb2hex( gradblue( idx(num),:)))};
        else
            entry.Style = {BackgroundColor(rgb2hex( gradred(idx(num),:)))};
        end
    end
end

tb.Style = {Width('100%'),...
           Border('none'),...
           ColSep('none'),...
           RowSep('none')};



%tb.Style={RowHeight('0.3in'),RowSep('solid'),ColSep('solid')};
tb.Width= '3in';
tb.TableEntriesVAlign = 'middle';
tb.TableEntriesHAlign = 'center';
%tb.Border = 'single';
add(rpt,tb)
close(rpt)
rptview(rpt)

The output of the code is not according to my desire.

The colorGradient and hex_and_rgb_v1.1.1 are linked here.

score 0 · Accepted Answer · answered Feb 22 '21 at 18:28

I myself have figured out the problem and twitched the algorithm and achieved my required results. Here is the code to do it.

clear all
addpath('hex_and_rgb_v1.1.1')
addpath('colorGradient')
format short

z=[
0 0.5 1;
0.5 0.3 0.33;
0.8 0.9 0.10;
];
zt = reshape(z.',1,[]);
colour1=colorGradient(hex2rgb('#2777c4'),[1 1 1],size(z,1)*size(z,2)); 
colour2=colorGradient(hex2rgb('#5e1a2b'),[1 1 1],size(z,1)*size(z,2)); 

import mlreportgen.report.*
import mlreportgen.dom.*
rpt = Report('zebraTable','pdf');
formattedNumbers = arrayfun(@ (n) sprintf("%1.3f", n),z);
tb = Table(formattedNumbers);

% Conditional formatting for table entries
nRows = tb.NRows;
nCols = tb.NCols;
num=0;
for iRow = 1:nRows
    for iCol = 1:nCols
       num=num+1;
        entry = tb.entry(iRow,iCol);
        entryContent = entry.Children.Content;

        if str2double(entryContent)>0.49
            entry.Style = {BackgroundColor(rgb2hex( colour2( sum(zt>=str2double(entryContent) ),:)))};
        else
           entry.Style = {BackgroundColor(rgb2hex( colour1( sum(zt<=str2double(entryContent)),:)))};
        end
    end
end

tb.Style = {Width('100%'),...
           Border('none'),...
           ColSep('none'),...
           RowSep('none'),...
           HAlign('center') };

tb.Width= '3in';
tb.TableEntriesVAlign = 'middle';
tb.TableEntriesHAlign = 'center';

add(rpt,tb)
close(rpt)
rptview(rpt)

How can I export a Matlab 2D array in Conditional Formatted table in pdf using MATLAB Report Generator?

1 Answers1