how to write data to xls sheet?
조회 수: 7 (최근 30일)
이전 댓글 표시
value_F = 0.1,0.2,0.3,0.4,0.5,0.6
filename = 'C:\Documents and Settings\admin\Desktop\test.xlsx';
value_F
Data= {'value_F';value_F};
sheet = 1;
xlRange = 'B';
xlswrite(filename,Data,sheet,xlRange)
where value_F is calculated from simulink model and asiigned to workspace,,,am able write oly value_F,,,am unable to write all the values of value_F
댓글 수: 1
채택된 답변
Image Analyst
2013년 1월 24일
Try using 'B1' for the range and not just 'B' - it should correspond to what ranges look like in Excel. Next, all cells in your cell array go into a cell in Excel, so you can't have a whole array in one cell. I've looked over my Excel writing code and I put all each element in a numerical array into their own cell. So have a for loop where you iterate over all numbers in your numerical array and put them into their own cell, something like this (untested):
[rows columns] = size(value_F);
myCellArray = cell(rows+1, columns);
myCellArray{1,1} = 'value_f'; % First row has only this
% Now assign rows 2 and lower of our cell array.
for col = 1 : columns
for row = 1
myCellArray{row+1, column} = myNumericalArray(row, column);
end
end
xlswrite(filename, myCellArray, sheet, xlRange)
댓글 수: 0
추가 답변 (3개)
Sachin Ganjare
2013년 1월 24일
Check the type of workspace output variable using "whos ,var_name". It could be a problem with type of data being written in excel.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!