export a uitable with backgound color

Question

Jingwen Sun 2023 年 10 月 3 日

0
リンク

この質問への直接リンク

https://jp.mathworks.com/matlabcentral/answers/2028645-export-a-uitable-with-backgound-color

回答済み: Sreeram 2024 年 9 月 6 日

Hi all,

I met a problem when I want to export my uitable where some cells have their own background color.

I tried

>> exportapp(fig, 'my_uitable.jpg');

>> exportapp(fig, 'my_uitable.pdf');

but unfortunately, it is a capture of the screen. My uitable has about 256 rows.

because

I tried Export UITABLE to HTML - File Exchange - MATLAB Central (mathworks.com)

thanks for the function uitable2html, but it does not work for me.

I tried (chatgpt)

WHAT I WANT is just to export the uitable with the backgound color, to a pdf, a html, etc.

Here is some of my codes to create a uitable.

fig = uifigure;

uit = uitable(fig,'Data',subregions);

for iSubregion = 1:length(subreg)

for iid = 1:height(pvalues_subreg)

if strcmpi(strcat('Region_', subreg{iSubregion}), pvalues_subreg.Var1{iid})

if any(pvalues_subreg.pvalues(iid) < palpha/(nsub+5))

s = uistyle('BackgroundColor',[1 0.8 0.8]);

addStyle(uit,s,'cell',[iSubregion,1]);

break;

end

Thanks a lot in advance for your help!!!

4 件のコメント
2 件の古いコメントを表示2 件の古いコメントを非表示

Dyuman Joshi 2023 年 10 月 4 日

To clarify, do you want to export the uifigure or the uitable?

Jingwen Sun 2023 年 10 月 4 日

hello, I want to export the uitable with background color.

サインインしてコメントする。

サインインしてこの質問に回答する。

Answer 1

Rahul 2024 年 9 月 6 日

0
リンク

この回答への直接リンク

https://jp.mathworks.com/matlabcentral/answers/2028645-export-a-uitable-with-backgound-color#answer_1511874

MATLAB Online で開く

Hi @Jingwen Sun,

I understand that you wish to export a 'uitable' with some styling like background color. You wish to obtain the table as a ',pdf' file or '.html' file etc.

One of the workarounds you can use to achieve this is mentioned below:

In this workaround you can create a '.png' file initially and then you can use the '.png' file to create the '.pdf' or '.html' files.

You can add this code to your script to your existing code in order to obtain the 'uitable' as a '.png' file

% Capture the figure as an image
frame = getframe(fig);
img = frame.cdata;
% Save the image
imwrite(img, 'uitable_image.png');

Now using the code mentioned below, you can obtain a '.pdf' file from the '.png' file created before

import mlreportgen.dom.*;
doc = Document('my_uitable', 'pdf');
append(doc, Image('uitable_image.png'));
close(doc);

Now to obtain a '.html' file from the '.png' file created, you can follow this code:

htmlFile = fopen('my_uitable.html', 'w');
fprintf(htmlFile, '<html><body><img src="uitable_image.png" alt="UITABLE"></body></html>');
fclose(htmlFile);

Functions like 'imwrite', 'Document', 'fprintf' help in achieving the desired result of exporting the 'uitable' element to a '.png', '.pdf', '.html' file respectively.

Note: The 'uitable2html' function that you are trying to use is only able to convert numerical data and is provided by a 3rd party: https://fr.mathworks.com/matlabcentral/fileexchange/58438-export-uitable-to-html?s_tid=srchtitle_support_results_4_uitable%2520export

You can refer to the following Mathworks documentations to know more about these functions:

'imwrite': https://www.mathworks.com/help/releases/R2024a/matlab/ref/imwrite.html?searchHighlight=imwrite&s_tid=doc_srchtitle

'Document': https://www.mathworks.com/help/releases/R2024a/rptgen/ug/mlreportgen.dom.document-class.html?searchHighlight=Document&s_tid=doc_srchtitle

'fprintf': https://www.mathworks.com/help/releases/R2024a/matlab/ref/fprintf.html?searchHighlight=fprintf&s_tid=doc_srchtitle

Hope this helps! Thanks.

0 件のコメント
-2 件の古いコメントを表示-2 件の古いコメントを非表示

サインインしてコメントする。

Answer 2

Sreeram 2024 年 9 月 6 日

0
リンク

この回答への直接リンク

https://jp.mathworks.com/matlabcentral/answers/2028645-export-a-uitable-with-backgound-color#answer_1512184

script.m

Hi Jingwen,

I understand that you are trying to export a UITable along with the background colour of the cells. Although I could not find any direct method to do that, I can suggest a workaround to achieve this, inspired by this answer.

Pull the data from the table using “get(uit,'Data')” and save it to an Excel file using the “writematrix” function. Then, in a loop, for each style configuration (which includes the background colours added using “addStyle”) of the table, apply it to the Excel workbook. You can get all the style configurations of the table using the “get(uit,'StyleConfigurations')” command. To set a colour to an Excel sheet cell, I followed the guide given here:

https://www.mathworks.com/matlabcentral/answers/215716-color-the-particular-row-of-the-excel-sheet#answer_178372

Now you have the UITable’s data and cell background colours exported to an Excel file.

For your reference, I am attaching my code to do this. Here’s a comparison of the UITable and the exported Excel file: