How to open cell array in excel?

2 次查看（过去 30 天）
kitty varghese
kitty varghese 2018-11-29
评论： Walter Roberson 2018-11-29
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.

请先登录，再回答此问题。

回答（2 个）

madhan ravi
madhan ravi 2018-11-29
编辑：madhan ravi 2018-11-29
I think you mean from excel file - then use readtable() to read the file
celldisp() to view the contents of each cell
  3 个评论
显示 1更早的评论
madhan ravi
madhan ravi 2018-11-29
celldisp() is used to display the contents in a cell array btw what are you trying to achieve?
kitty varghese
kitty varghese 2018-11-29
I want to copy the content of cell array into excel file

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2018-11-29
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.
  1 个评论
Walter Roberson
Walter Roberson 2018-11-29
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by