How do I extract value from a Cell array to text file or CSV file?

2018 10 24
2 个回答
回答已采纳
更新时间：2020 4 10
9 次查看（30 天）

0 个投票

I have a figure with some exact(detected) point. See the figure.
I want to find the X-Level value and Y-Level value of the detected points. I found the code on this website. It works also good. The code is given below:
ax = gca;
obj_with_xd = findobj(ax, '-property', 'XData');
obj_with_right_markers = findobj(obj_with_xd, 'Marker', 'v', '-or', 'Marker', 'o', '-or', 'Marker', 's');
the_xd_cell = get(obj_with_right_markers', 'XData');
if ~iscell(the_xd_cell); the_xd_cell = {the_xd_cell}; end
the_yd_cell = get(obj_with_right_markers, 'YData');
if ~iscell(the_yd_cell); the_yd_cell = {the_yd_cell}; end
From this code, I want to extract the the_xd_cell and the_yd_cell Cell Array value in a text file or CSV file in that way like such that, R1: X-level: 42, Y-level: 0.908 again R2: X-level: 137, Y-level: 0.854 and so on for all detected point of RQS (Q1, Q2...).. How can I do that?
I also attached 2 screenshots for your easiness. The the_xd_cell cell is given below:
Some value of the_xd_cell is given below:
Help to solve this problem.

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

 采纳的回答

madhan ravi
madhan ravi 2018-10-25
编辑：madhan ravi 2018-10-25

0 个投票

EDITED
the_xd_cell=load('the_xd_cell.mat')
the_xd_cell1(1,:)=the_xd_cell.the_xd_cell{1}
the_xd_cell2(1,:)=the_xd_cell.the_xd_cell{2}
the_xd_cell3(1,:)=the_xd_cell.the_xd_cell{3}
dlmwrite('sample.txt',the_xd_cell1,'delimiter',' ')
dlmwrite('sample.txt',the_xd_cell2,'delimiter',' ','-append')
dlmwrite('sample.txt',the_xd_cell3,'delimiter',' ','-append')

15 个评论
显示 13更早的评论 隐藏 13更早的评论

Akib Rahman
Akib Rahman 2018-10-25
When I run your code, it shows me this error!
Error using dlmwrite (line 104)
The input cell array cannot be converted to a matrix.
madhan ravi
madhan ravi 2018-10-25
Use the_xd_cell=mat2cell(the_xd_cell)
Akib Rahman
Akib Rahman 2018-10-25
Error using mat2cell (line 45)
Not enough input arguments.
madhan ravi
madhan ravi 2018-10-25
the_xd_cell=load('the_xd_cell.mat')
the_xd_cell=the_xd_cell.the_xd_cell{3}
dlmwrite('sample.txt',the_xd_cell,'delimiter',',')
Akib Rahman
Akib Rahman 2018-10-25
@Ravi. Thanks for your answer and patience. Your code converts the_xd_cell and taking help from your code I can convert the_yd_cell. But I want the output in another way what I describe in the questions. That's mean I want every detected point X and Y coordinates. I hope will help me :)
Akib Rahman
Akib Rahman 2018-10-25
@Ravi. I also have done the concatenation of X and Y cell value. See the photo:
But actually I want in this way:
madhan ravi
madhan ravi 2018-10-25
编辑：madhan ravi 2018-10-25
I'll give an example for your to understand:
x=1:10
Y=10:-1:1
x(Y==7) % what does this do it extracts value of x when Y is 7
x(Y==Y) %extracts all x coordinates with corresponding Y cooedinates
like wise you can apply it to your case
Akib Rahman
Akib Rahman 2018-10-25
Though I am new in Matlab. But its ok. I use your code create a text file and convert this text file in CSV file. Thanks for your help.
Akib Rahman
Akib Rahman 2018-10-26
@Ravi, Hello, if you take a look at the first figure the_xd_cell is 3 * 1 cell. So when I run first time (guess cell 1 contains the data of square type object) but when I run the second time (cell 1 contains circle type object data). That's mean cell number is changing for different object type when I run the program second or more time.
How can I do the cell number constant (Like that cell 1 is always for square type object and cell 2 is always circle type object)

请先登录，再进行评论。

更多回答（1 个）

KSSV
KSSV 2018-10-25

0 个投票

C{1} = rand(1,26) ;
C{2} = rand(1,25) ;
C{3} = rand(1,26) ;
A = cell2mat(C)' ;
save 'data.txt' A -ascii

2 个评论
显示 无 隐藏 无

Akib Rahman
Akib Rahman 2018-10-25
@KSSV After running your code, it generates a text file but my result is fully changed!
KSSV
KSSV 2018-10-25
They ate not changed.....you load it back into MATLAB using load and see....it is a format display that's it. Else you can use fprintf to save by specifying the format.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by