How to insert data in to a excel file?
조회 수: 4 (최근 30일)
이전 댓글 표시
Hello all, I have a program which gives me 240 data,I want to put this 240 data in a excel file. for every column I have 20 data,I mean 20 data for File a,20 data for File d, 20 for R,20 for Maximum value and 20 for x and 20 for y. afilename is the name of the variable of the File a which is different in every 20 data. and also for dfilename and r and maximum and mim1 and nim1 . All of them are variable for their data which are changing in every time I run the program. Can anyone help me in this?
ex = {'File a','File d','r','Maximum Value','x','y'; afilename ; dfilename ; r ; maximum ; mim1 ; nim1 }; xlswrite('Subtract1', ex, 1, 'A1')
댓글 수: 0
채택된 답변
Image Analyst
2014년 1월 24일
You can use xlswrite() and it will work, but it will take a long time for 20 files, since it has to launch Excel 20 times and shutdown Excel 20 times. Better is to use ActiveX. It's more complicated programming but it's a lot faster since you only have to launch Excel once. I've attached a demo below in blue text.
댓글 수: 0
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!