필터 지우기
필터 지우기

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

조회 수: 44 (최근 30일)
Tania
Tania 2015년 2월 12일
댓글: 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.

답변 (3개)

Julia
Julia 2015년 2월 12일
Hi,
there exists the command
xlswrite()
Does this suit your purpose?
  댓글 수: 4
Tania
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
Vito 2015년 2월 15일
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;
Create your database and get or set data.

댓글을 달려면 로그인하십시오.


Image Analyst
Image Analyst 2015년 2월 12일
편집: Image Analyst 2015년 2월 12일
See my Excel demo. It uses ActiveX and will be a lot faster than xlswrite if you need to make multiple writes.
Another option is you could put your data into a table (if you have R2013b or later) and then call writetable().
  댓글 수: 10
bim
bim 2023년 1월 1일
@Image Analyst: I packed the functionality for reading in a simple static class so it can be easily reused.
It will only read contiguous tables and for now only reads tables with columns with a single digit name (A-Z).
I have not benchmarked it against importdata yet.
Image Analyst
Image Analyst 2023년 1월 1일
OK, that's good. I also have a static class with a ton of functions for doing stuff in Excel, like formatting cells, etc. It's attached.

댓글을 달려면 로그인하십시오.


Md Iqbal
Md Iqbal 2020년 10월 16일
How to save data from matlab GUI edit text box to excel
  댓글 수: 1
Image Analyst
Image Analyst 2020년 10월 16일
From GUIDE, App Designer, or inputdlg()?
Have you tried writematrix() or writecell()?

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by