Extract cell with number lines and columns

Hello, I would like to automatically extract a cell of 1 row and 20 columns among so many others,

what functions do you think I can use?

thank

Have a good day

[Akshay Malav]

From where you want to extract a matrix or from a file

[manon bess]

to extract a matrix yes

Answer 1

[KSSV]

Read about xlsread and readtable.

Answer 2

[manon bess]

In a matrix, I have several cells.

I would like to automatically retrieve the cell 1x20 cells by indicating that there are 20 columns and 1 row

Answer 3

[Akshay Malav]

Okay here is the explaination

Let's say that you have a cell Array A which contains a cell array inside it ,it has dimension from 1 to 100 you can change it to your size of array.

Now I have just looped through the array A and for each element of array A which is A{i} checked it's size and then stored that cell in b array .

Hope this helps

A = cell(1,100);
A{4} = cell(1,20);
A{5} = cell(1,33);
A{6} = cell(1,20);
A{7} = cell(1,20);
b = []; 

for i = 1:100
    [row col] = size(A{i});
    if row == 1 & col == 20
        b = [b A{i}];
    end
end

Answer 4

[manon bess]

Thanks, I made it!

but how do we get the values instead of the idx?

Answer 5

[Akshay Malav]

So let's say A is the cell array and you want to access it's 4th element then you can do A{4} . And now if you want to access let's say 6th element of A{4} then you can do A{4}{6}

Hope it helps

Answer 6

[manon bess]

yes, but there are " cells".. so I like to get the values.