How to store 5 or 6 files output into same excel file
이전 댓글 표시
Hi all, I got an output for one input file and I am able to store it in an Excel file but I m unable to store the outputs of 5 or 6 different data files into the same sheet at different locations.
I m using the following lines to store the output of one specific file into an Excel sheet.
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', t(record2),'Sheet1','A2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', Z2(record2),'Sheet1','B2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', surfacearea1,'Sheet1','C2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', surfacearea2,'Sheet1','D2');
Can anyone help me in storing outputs for 5 or 6 different files into same excel sheet at different locations. So that when the file opens i can see all the ouputs displayed in one sheet.
댓글 수: 3
the cyclist
2011년 3월 23일
Can you be more specific about what happens when you do the commands listed there? (I can't do it myself, because xlswrite does not work on a Mac.)
Are you getting anything at all written to the Excel file?
santosh
2011년 3월 23일
the cyclist
2011년 3월 23일
What are the sizes of the arrays you are writing? Maybe they are not the sizes you expect? Maybe surfacearea1 and surfacearea2 are accidentally scalar instead of vector?
채택된 답변
추가 답변 (0개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!