MATLAB Answers

0

how to make all cells in uitable editable in matlab GUI and save them when i press pushbutton ? how to read all contents from xlsread array

Asked by Vasishta Bhargava on 23 Jun 2018
Latest activity Edited by Vasishta Bhargava on 25 Jun 2018
I have GUI which has uitable. I want to read data into table and display when I select options in the listbox ... The GUI also has two push buttons edit and save to enable edit and save after I make changes I am using xlsread to read data into array. however, for some reason, it reads all the cells but not the first two rows of excel file which has text

  0 Comments

Sign in to comment.

1 Answer

Answer by Walter Roberson
on 23 Jun 2018
 Accepted Answer

[~, ~, raw] = xlsread('YourFile.xls');
Now raw will contain headers and all.
h = uitable('data', raw, 'ColumEditable', true(1, size(raw,2)));

  5 Comments

It outputs the same format as before ... An interesting change I observed is when I place a number in first row and first column it starts to read the all the sheets in cell array, displaying the number of matrix elements in each element of cell array like this instead of sheetname
Columns 1 through 8
{62×55 double} {51×55 double} {60×55 double} {0×0 double} {0×0 double} {0×0 double} {0×0 double} {0×0 double}
Columns 9 through 11
{0×0 double} {0×0 double} {0×0 double}
how can I read them using xlsread now ... when I do that in this format
data= xlsread('file.xlsx',Sheets{1});
it shows error
Sheet argument must be a character vector or an integer.
Ok, I got it now ...
but how do I write the data contents to specific cell/s of uitable after I read it using xlsread
It is not possible to directly write to specific cells of a uitable. All you can do is create a numeric array (if your data is pure numbers) or cell array (if you have some non-numeric entries) and put things where you want in that array, and then set the resulting array as the Data property of the uipanel.
uitable is not a spreadsheet; you cannot address parts of it, and there are no macros, and it is not very flexible about formatting.

Sign in to comment.