export a uitable with backgound color

Question

Jingwen Sun 2023년 10월 3일

0
링크

이 질문에 대한 바로 가기 링크

https://kr.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://kr.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://kr.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: