MATLAB: How to fill a uitable with excel data

uitablexlsread

Thanks for read this. Well, I want to read an excel spreadsheet, but I think I should use a uitable because I need to update the columns I want to use to do operations with them. For example, I have an excel spreadsheet with 10 columns, but I don´t know how many columns and what columns will use the user. I have the way to update the size of the table, it means, the number of columns, but I want to fill it with excel data. If there's another way to do what I'm trying to do, please let me know. Thanks again. Pd. I apologize for my english.

Best Answer

Do you want the excel sheet to be available and then have the user select from it? You can call up the whole sheet within matlab and it will be interactive and selectable. Or you can use this http://www.mathworks.com/help/matlab/ref/readtable.html

If I am understanding what it is you want to do properly.

Related Solutions

MATLAB: How to convert from table form to excel sheet

writetable(as,'myData.xlsx')

thank you guys

MATLAB: Uitable

An alternative:

How do I change the color of individual cells in uitable in MATLAB 7.10 (R2010a)?

You could modify:

function outHtml = colText(inText, inColor)
% return a HTML string with colored font
outHtml = ['<body bgcolor="Silver", font color="', ...
inColor, ...
'">', ...
inText, ...
'</font></body>'];
end

Note the bgcolor, however the result is not so nice (but you can customize each cell).

Another thing you could do is play with the 'BackgroundColor' property, but it affects all cells or you can customize odd, even.

Java: http://undocumentedmatlab.com/blog/uitable-cell-colors/

Best Answer

Related Solutions

MATLAB: How to convert from table form to excel sheet

MATLAB: Uitable

Related Question