Cell data in one colum

4 views (last 30 days)
Auryn_
Auryn_ on 24 Nov 2015
Commented: Image Analyst on 25 Nov 2015
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 Comment
Image Analyst
Image Analyst on 25 Nov 2015
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?

Sign in to comment.

Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!