export a uitable with backgound color

6 visualizaciones (últimos 30 días)
Jingwen Sun
Jingwen Sun el 3 de Oct. de 2023
Respondida: Sreeram el 6 de Sept. de 2024
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
end
end
end
Thanks a lot in advance for your help!!!
  4 comentarios
Mostrar 2 comentarios más antiguos
Dyuman Joshi
Dyuman Joshi el 4 de Oct. de 2023
To clarify, do you want to export the uifigure or the uitable?
Jingwen Sun
Jingwen Sun el 4 de Oct. de 2023
hello, I want to export the uitable with background color.

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuestas (2)

Rahul
Rahul el 6 de Sept. de 2024
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.
Sreeram
Sreeram el 6 de Sept. de 2024
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:
You can programmatically save this Excel file as a PDF. For the details on how to print it, you can see this guide:
http://www.mathworks.com/matlabcentral/answers/96670
I hope this could help!

Categorías

Más información sobre Develop uifigure-Based Apps en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by