清空筛选条件
清空筛选条件

Export data to excel or text file directly

1 次查看（过去 30 天）
Fayyaz
Fayyaz 2014-7-6
回答： Image Analyst 2014-7-6
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 个评论
显示 2更早的评论
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by