loop for excel in MATLAB
3 次查看(过去 30 天)
显示 更早的评论
hi all, I want to save values from MATLAB to excel so I want to write a loop to check if the cell has a value or not, for example: lets consider the column (B) I want the matlab to start checking from B4 which one is empty cell to save the new values in it, how this can be done ?? looking for your help please.
2 个评论
采纳的回答
更多回答(1 个)
Andrei Bobrov
2012-6-7
one way
[nt,nt,nt] = xlsread('nameyour.xlsx');
nt(cellfun(@isnan,nt)) = {256};
xlswrite('nameyour.xlsx',nt)
ON Samer's reply
eg, data:
xlswrite('Data_sheet.xlsx',[1;8;1;6;1],'B1:B5')
solution
a = 100;
[n,t,nt] = xlsread('Data_sheet.xlsx','B1:B5');
n(n == 1) = a;
xlswrite('Data_sheet.xlsx',n,'B1:B5')
3 个评论
Image Analyst
2012-6-8
He's setting those Excel cells (which are now in a MATLAB cell array called nt) that are not numbers to have the new value of 256. You can change the 256 to whatever number you want. Then it writes if back out to the same file. If you want just some submatrix (like B4..F42), then you'd have to extract that submatrix before running andrei's code on just that submatrix. Then insert the submatrix back into the full matrix and write out the full matrix.
Andrei Bobrov
2012-6-8
Thank you Image Analyst! Such a good explanation difficult for me (English is not my mother tongue).
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!