Cell data in one colum

1 回表示 (過去 30 日間)
Auryn_
Auryn_ 2015 年 11 月 24 日
コメント済み: Image Analyst 2015 年 11 月 25 日
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 件のコメント
Image Analyst
Image Analyst 2015 年 11 月 25 日
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?

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by