Cell data in one colum

1 次查看（过去 30 天）

显示更早的评论

Auryn_ 2015-11-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257329-cell-data-in-one-colum

评论： Image Analyst 2015-11-25

在 MATLAB Online 中打开

Hello,

I have a cell saved as a .mat file.

The file contains several cells. When I open each cell instead of showing the data in excel separate by columns it merges everything showing this:

val =

   (2,1)       2.0000
   (3,1)       3.0000
   (4,1)       4.0000
...
   (2,2)       0.0631
   (3,2)       0.0631
   (4,2)       0.0631
   (5,2)       0.0631
...
and so on, instead of showing the data in different columns.

How can I separate the values per columns?

NOTE: I did the exercise before and it was showing perfectly the different columns. What could it be wrong?

Thanks a lot in advance for your reply.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2015-11-25

在 MATLAB Online 中打开

What do you mean by "open each cell"? xlsread() can return two cell arrays and one numerical array

[numericalMatrix, cellArrayStrings, cellArrayRaw] = xlsread(filename);

When you say "cell" do you mean like a MATLAB cell like is described in the FAQ http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F, or do you mean a cell like what Excel calles cells but MATLAB calls elements. And again, how do you "open" it?

How did you get that display? Did you just put val by itself on the line of code or in the command window? Or you did something else to generate it?

请先登录，再进行评论。

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