Export data to excel or text file directly

1 次查看(过去 30 天)
Hello,
As a result of below coding I get the file name "out".
Origin = (1:81)';
Destination = (1:81)';
Survey_Location = (1:246)';
[z,y,x] = ndgrid(Survey_Location,Destination,Origin);
out = [x(:),y(:),z(:)];
I can't copy the data, as it says data is too big to copy.
Kindly let me know how can I directly get the result or export this "out" file into Excel or txt file.
Thanks
  4 个评论
Fayyaz
Fayyaz 2014-7-6
The order of the "out" matrix is 1614006*3. When I open it in Matlab work space window and click on copy, below message appears:
Too much data selected for copy. Try one or more of the following:
Export the data directly to file
Or select few data
Increase memory of Java.
So I was wondering if there is any method of directly getting the output in excel or txt file, it will be better.
Fayyaz
Fayyaz 2014-7-6
@Image Analyst: There is NO problem in the code. It works perfect. The problem is I can't export the output to excel or txt, i.e. why I posted differently.

请先登录,再进行评论。

采纳的回答

Image Analyst
Image Analyst 2014-7-6
Don't try to copy the data from the workspace. Maybe the clipboard is not big enough, though I think it should be. Try using a function to write it out, like xlswrite() or csvwrite().

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by