How to open cell array in excel?

I have a cell array of size {C}=100x1 and inside each cell there is a column vector of varying length. For eg. C{1,1}=50x1,C{2,1}=100x1 and so on. I want to read this cell arrray in excel file.

[KSSV]

What do you mean by read cell array in excel??

[kitty varghese]

excel sheet

Answer 1

[madhan ravi]

I think you mean from excel file - then use readtable() to read the file

celldisp() to view the contents of each cell

[kitty varghese]

I;m using the following code to store it using celldisp. However Iam getting error "Too many output parameters"

for i=1:100
    c(i)=celldisp(C{I,1})
end

[madhan ravi]

celldisp() is used to display the contents in a cell array btw what are you trying to achieve?

[kitty varghese]

I want to copy the content of cell array into excel file

Answer 2

[Walter Roberson]

Excel is not able to represent anything like that.

The most direct match might be if you made every cell into a different Excel "sheet".

The second best match would be if you were to make each column of a normal sheet a different size. If you were to read a specific range such as B:B then you would get back just that one column. If you did not read a particular range, then the numeric array you would get back would have the same number of rows for all columns, but the unused entries would show up as nan.

[Walter Roberson]

To read a particular sheet from an xls or xlsm file, you can use xlsread() passing in the sheet information after the file name, or you can use readtable() with the 'sheet' option.

To write to a particular sheet of an xls or xlsm file, you can use xlswrite() passing in the sheet information as the third parameter (after the file name and data to be written), or you can use writetable() with the 'sheet' option.