How to import data from MATLAB into Excel, and then have Excel save the data

37 次查看（过去 30 天）

Tania 2015-2-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/177887-how-to-import-data-from-matlab-into-excel-and-then-have-excel-save-the-data

评论： Image Analyst 2023-1-1

Hi everyone,

I have extracted some features from images and they can be seen in the command window. There are too many blob information which needs to be saved in excel file from MATLAB command window.

Could anyone please help me how to save them in a excel file or text file automatically so that it can be used later on rather than running the process to see the values over and over unless I save them manually by copying and pasting them in text file / excel file.

Any help will be appreciated.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（3 个）

Julia 2015-2-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/177887-how-to-import-data-from-matlab-into-excel-and-then-have-excel-save-the-data#answer_167779

在 MATLAB Online 中打开

Hi,

there exists the command

xlswrite()

http://www.mathworks.com/help/matlab/ref/xlswrite.html

Does this suit your purpose?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Tania 2015-2-13

Hi Vito,

Thank you for your suggestion but I am not sure how to do that.

If you do have any written program available as Image Analyst have given in his post, could you please give me like that.

Thanks

Vito 2015-2-15

在 MATLAB Online 中打开

The images do not, but the problem is clear. Excel is not suitable. As an example, monitoring Facebook.

% insert data
exdata = []; % dataset
.....
conn = database('facebook', '', '');
colnames = {'a', 'd'}
fastinsert(conn, 'RELATION', colnames, exdata) 
......................
% get data 
conn = database('facebook', '', '');
curs = exec(conn,['SELECT * From RELATION']);
curs=fetch(curs);
Set=curs.Data;