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

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

Answer 1

[Walter Roberson]

[~, ~, raw] = xlsread('YourFile.xls');

Now raw will contain headers and all.

h = uitable('data', raw, 'ColumEditable', true(1, size(raw,2)));

[VBBV]

It shows data in a different format without specific relation to sheet with this code ...[~, ~, raw] = xlsread('YourFile.xls'); which I am not able to interpret correctly

but when I use the following code

[~,All]=xlsfinfo('File.xlsx')
for k=1:numel(All)
  Sheets{k}=xlsread('File.xlsx',All{k})
end

It produces all the sheet names and reads the data in sheet

But when i try to read data from individual sheet using the code below

dataA{k}=xlsread('File.xlsx',sheetname{k})

it reads everything except the first two rows in sheet which contains text info

[Walter Roberson]

[~,All]=xlsfinfo('File.xlsx')
for k=1:numel(All)
 [~, ~, Sheets{k}] = xlsread('File.xlsx',All{k})
end

[VBBV]

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.

[VBBV]

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

[Walter Roberson]

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.